Showing posts with label dynamic. Show all posts
Showing posts with label dynamic. Show all posts

Wednesday, March 21, 2012

Reports with dynamic user entered parameters.

I am new to Crystal Reports. I am getting into reports and need to design few first crystal reports. I have read some tutorial and created simple once with no problems.
However I am looking for an ability to create ASP.NET page with crystal report where user will be able to select different parameters that will be passed to stored procedures to generate different reports For example select the date or user name or something like that. I know that I can design selection part in ASP.Net and then pass it to crystal report to generate dynamic report. I was just wondering if Crystal report has this option build in where I will not have to create separate AS.NET promt controls abut use Crystal Once and put it on the same page where user selects parameters clicks some button SUBMIT and gets report, then chage para,etrs and get different report. I hope I explained it well to understand

Thanks for any help !!!!anybody, please??|||I was just wondering if Crystal report has this option build in where I will not have to create separate AS.NET promt controls abut use Crystal Once and put it on the same page where user selects parameters clicks some button SUBMIT and gets report, then chage para,etrs and get different report. I hope I explained it well to understand

I'm not sure I understand what you're asking. Can you restate your question?

Linda|||I am trying to create dynamic crystal report. What I mean by "dynamic" is I would like to have some controls like textBox or ComboBox that will collect some parametrs from user and will be imported into SQL statement wihtin crystal report to retrevie different results. For example, I have report that gives me daily activty of the store. I want to have control that has promts user for a date and depending on user entry diplay report for following day.

I know that I can create the controls in Windows.Forms or In ASP.NET and then pass it to crystal report. But I was wondering if there is such functionality built in crystal reports where I can user control to insert parametrs. I have seen it somewehere that it was done but in 2 pages where user select the parametrs first and then get report, but I want to have it on one page like for example parametrs selection on top and report on the botom of the page

Thanks!!!|||I am trying to create dynamic crystal report. What I mean by "dynamic" is I would like to have some controls like textBox or ComboBox that will collect some parametrs from user and will be imported into SQL statement within crystal report to retreive different results. For example, I have report that gives me daily activty of the store. I want to have control that promts user for a date and depending on user entry diplay report for enterted day.

I know that I can create the controls in Windows.Forms or In ASP.NET and then pass user entry to crystal report. But I was wondering if there is such functionality built in crystal reports where I can user control to insert parametrs. I have seen it somewehere that it was done but in 2 pages where user select the parametrs first and then get report, but I want to have it on one page like for example parametrs selection on top and report on the botom of the page

Thanks!!!|||If I understand you correctly, you want to prompt the user for parameters and display those parameters along with the report?

Have you thought about using frames? You could use the top frame for the parameters and the bottom frame to display the report.

Alternately, you could display the parameter fields right in the report.

Linda|||Thanks for the answer

Well, I want a little bit differetn think. I want user to be able to enter some parametrs and then click some button what will display report based on parametrs. So I do not wnat just to display parametrs in report but have report use these parametrs lets say in WHERE clause in SQL command or as paramters in Stored Procedures. So this way user will be able to slect different paramters and siplay differetn reports

?

Thanks|||I *think* I've read that you can design an entire report programmatically, but I've never attempted anything like that myself. I'm not sure I would want to unless there weren't any other way. IMO it's just easier to design a report in the report designer and then hook into it programmatically and pass some pre-defined parameters.

What kind of SDK's do they have for ASP.Net on the Business Objects site? I'm still ASP based with Crystal and use the RDC and RAS SDK's for COM. They usually post the SDK's in the Developer Zone, but you might have comb the BO site or buy a really good book to be able to do something like that.

Linda|||Thanks for your answers. I am just a begginer with crystal reports so any advice is valuable to me.

Alternately, you could display the parameter fields right in the report.

Can you please tell me or send a link to some tutorial that talks about how to do it.

[qoute]What kind of SDK's do they have for ASP.Net on the Business Objects site?[/quote]

If I exactly uinderstood you I am using Visual Studio to develop any ASP.NET based projects.

Thanks a lot

Reports using Dynamic Columns

Hi..
I am facing a problem with the SQL reporting Service and also am pretty much new to the reporting service…

I need to create a yearly report from a table called say tblData. It has rows like
[items] [Amount] [Date].
Item1 100 05/2005
Item1 110 06/2005
Item2 200 05/2005
Item2 230 06/2005

Now I want the report like
[Items] [First month] [Second month] etc...

The data for the first month, second month etc will be the [amount] for that month.
ie the report rows should be like

[item] [05/2005] [06/2005]

item 1 100 110
item 2 200 230

In the report the month columns will be dynamic according to the data in the tblData table...

Now how should I implement this?

First I though of writing up a Stored Procedure so that the sp returns the formatted data (i.e. a returning a table having the having the dynamic columns). But how can I create the report using these dynamic columns in the reporting service?

Thanks in advance for the replies…
ASMSYou can achieve this with a matrix report item and using a column grouping expression of =Year(Fields!Date.Value)*100 + Month(Fields!Date.Value) to achieve the grouping based on Month/Year.

You may also want to take a look at the sample reports that ship with RS 2000 and RS 2005. Specifically, look at the "Company Sales" report sample.

-- Robert

Saturday, February 25, 2012

Reporting SVCS and OLAP

Hello
I have question about OLAP and reporting services, is there any way, or any
add in component for Reporting SVCS, for dynamic olap table. First when i
read feature of Reporting services i read something about integration with
OWC so i was thougt that i can add OWC PivotTable like component on my
Report, but this is not or so....
Is also there any SDK how to buil own component for Reporting Services
thank
Matej
Home page: http://magic.streznik.org
---Hi,
MS Reporting Services is for SQL Reporting and MS Analysis Services is
for MDX Reporting. With the addin of Panorama for MS Reporting
Services it is possible to have a MDX Report in MS Reporting Services
with parameters to choice from a slicer. With a simple click you can
go from static reporting in MS Reporting Services to the webclient of
Panorama for more analysis.
With QuickQuery And ReportBuilder you can make your own SQL Reports in
MS Reporting Services and in future also based on MDX Reports.
You can also use ReportPortal to have all in one concept.
On our website www.gmsbv.nl you will find more info, demos and trials.
Regards,
Marco
www.gmsbv.nl
"Matej Kavèiè" <matej.kavcic@.email.si> wrote in message news:<ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl>...
> Hello
> I have question about OLAP and reporting services, is there any way, or any
> add in component for Reporting SVCS, for dynamic olap table. First when i
> read feature of Reporting services i read something about integration with
> OWC so i was thougt that i can add OWC PivotTable like component on my
> Report, but this is not or so....
> Is also there any SDK how to buil own component for Reporting Services
> thank
> Matej
> Home page: http://magic.streznik.org
> ---|||Ok, there are two independent questions here.
1. OWC:
You might want to checkout MSDN at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
The dynamic pivot table functionality in Reporting Services is done via
Office Web Components (Office XP). Matrix reports (which you can build from
any type of data source) will be rendered as interactive pivot tables in
HTML with OWC.
2. Reporting from Analysis Services:
This question has come up several times on the newsgroup. You might want to
download and check out some samples from this link:
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
In addition, you may also want to subscribe to this discussion list:
http://groups.msn.com/OLAPServicesDevelopersForum. It should contain a
document in the discussion group under General about approaches how to
directly use Analysis Services 2000 as a datasource for Reporting Services
2000.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matej Kavèiè" <matej.kavcic@.email.si> wrote in message
news:ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> Hello
> I have question about OLAP and reporting services, is there any way, or
any
> add in component for Reporting SVCS, for dynamic olap table. First when i
> read feature of Reporting services i read something about integration with
> OWC so i was thougt that i can add OWC PivotTable like component on my
> Report, but this is not or so....
> Is also there any SDK how to buil own component for Reporting Services
> thank
> Matej
> Home page: http://magic.streznik.org
> ---
>|||There is also a MSDN article available now: "Integrating Analysis Services
with Reporting Services"
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/olapasandrs.asp
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:OxSEHJaVEHA.4092@.TK2MSFTNGP11.phx.gbl...
> Ok, there are two independent questions here.
> 1. OWC:
> You might want to checkout MSDN at
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSCREATE/htm/rcr_creating_dc_v1_43vn.asp
> The dynamic pivot table functionality in Reporting Services is done via
> Office Web Components (Office XP). Matrix reports (which you can build
from
> any type of data source) will be rendered as interactive pivot tables in
> HTML with OWC.
> 2. Reporting from Analysis Services:
> This question has come up several times on the newsgroup. You might want
to
> download and check out some samples from this link:
>
http://www.microsoft.com/downloads/details.aspx?FamilyID=f9b6e945-1f4c-4b7c-9c83-c6801f0576ff&DisplayLang=en
> In addition, you may also want to subscribe to this discussion list:
> http://groups.msn.com/OLAPServicesDevelopersForum. It should contain a
> document in the discussion group under General about approaches how to
> directly use Analysis Services 2000 as a datasource for Reporting Services
> 2000.
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Matej Kavèiè" <matej.kavcic@.email.si> wrote in message
> news:ebhlhMSVEHA.1292@.TK2MSFTNGP10.phx.gbl...
> > Hello
> >
> > I have question about OLAP and reporting services, is there any way, or
> any
> > add in component for Reporting SVCS, for dynamic olap table. First when
i
> > read feature of Reporting services i read something about integration
with
> > OWC so i was thougt that i can add OWC PivotTable like component on my
> > Report, but this is not or so....
> > Is also there any SDK how to buil own component for Reporting Services
> >
> > thank
> >
> > Matej
> > Home page: http://magic.streznik.org
> > ---
> >
> >
>