Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 1 Replies
ADVERTISEMENT
Mar 18, 2008
I have an already published application running several MS SQL Server 2000 Reporting Services report.
I need a way to find from either the reporting services log or the application server (IIS) logs or windows log
to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend?
How can I acheive this?
I have already got the IIS logs and it did not give the required info.
I have looked into the Reporting Services logs but it does not provide the info either.
Any help is appreciated
View 2 Replies
View Related
Mar 27, 2008
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID.
I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data:
1 - 50
60 - 80
150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Thanks,
Patrick Conway
View 9 Replies
View Related
Apr 23, 2007
I have abt 30 reports currrently in SQL 2000. My data still resides in SQL SERVER 2000. However, I need to convert these reports to SSRS 2005.
I want to use the cool features like sorting, multi-value parameters from the RS 2005.
Can you pl advise how I shud go abt converting these reports from RS 2000 TO RS2005 .
Thanks.
View 5 Replies
View Related
Jan 8, 2007
Hi,
Can anyone point me to any reference material, resources etc. on migration of SQL Server 2000 Reports to 2005?
Thanks,
Dave
View 3 Replies
View Related
Apr 18, 2007
Hi,
We just deployed a report solution and I would like to know when and how much each report is used. Is there a report for it ?
With regards,
Constantijn Enders
View 3 Replies
View Related
Feb 13, 2008
Hi Friends,
Could I migrate the reports which are developed on SQL 2000 to SQL 2005. If Yes then How ...
Could anyone explain me. How it works.
Thanks
sqlferns
View 2 Replies
View Related
Aug 13, 2013
I am having a problem with the disk usage reports after creating a centralised MDW on SQL Server 2008, this is the report displayed when you drill down onto a specific database.
When I drill down on a database on the local server to the MDW database the disk usage report is shown correctly.
However, when I drill down onto another servers database I receive the following error: A data source instance has not been supplied for the data source 'DS_TraceEvents'.
View 1 Replies
View Related
Mar 28, 2008
Hi,
I have a report that calls a stored procedure that creates an extract of data for use by various subreports. Now I have this problem:
If I save the extract data in a global temporary table, then it is automatically deleted before the subreports can use it, this means I have to create a normal table with a unique name that need to be deleted - but where do you do this in the report - there is no point where you can say it is now safe to delete a table?
I do not want to resort to external mechanisms, languages, jobs etc. to do this. I want to delete the table once the report is really finished in the report.
My main report uses a list that contains all the subreports as I need to group all sorts of information by vendor. The main report calls the stored procedure. Please do not tell me that I have to duplicate the main extract for every subreport. That will really eat resources.
Thanks in advance.
View 4 Replies
View Related
Feb 1, 2007
I have developed a report on my local machine and after the successful test on my machine uploaded the report on a webserver, where i have a report project and added the report as an existing item to the report project, i went to data tab and tried to change the datasource name to use a datasource name which is on the webservers report project, but it still complains saying there is a datasource name referred in that report, which matches with my local machines datasource name, how to remove all the references of my localmachines datasource name's.
Please help, i even went to xml side of the report code did see datasources tag on the top and i modified that too matching with a datasource name which is on webserver, still it complains including i modied the token key......
Thank you very much for then information.... this report cotains subreports too i modfied in all places, still i don't know what am i missing....
View 1 Replies
View Related
Sep 12, 2007
Is it possible to write SSRS 2008 reports to run on an existing SSRS 2005 server?
If yes, what do I need to do to be able to write SSRS 2008 reports on my developer PC that will run on the SQL 2005 Server (which also has SSRS 2005 installed on it)?
I installed Visual Studio 2008 beta on the development PC and it appears that it needs SSRS installed on it too. So I installed SQL 2008 SSRS (SQL Server Reporting Services) and SQL 2008 Workstation Components onto the developer PC. Next I run the SQL 2008 "Reporting Services Configuration" tool. When I click on the "Web Service URL" section it hangs indefinitely and I have to force it closed.
The developer PC is Windows Vista Business.
Any suggestions on making this work, or any other information that you can think of that would allow me to use Visual Studio 2008 and the SQL 2008 "Report Designer Preview" tool to develop SSRS reports that will run on the SQL 2005 SSRS server?
Thanks!
-ErikR
View 4 Replies
View Related
Nov 5, 2007
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports,
Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting
or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
Hal1490
Hal9000
View 4 Replies
View Related
Jan 23, 2007
Hi does anyone know how to do the above with out going through reportserver url?
Preferably by using a cmd tool ? such rs.exe
or through the backend in the reportserver DB?
Thanks
Dave
View 2 Replies
View Related
Feb 19, 2008
Hello all ...
I want to know which would be the best for reporting in either of the above two. I am working on with SSRS but don't have any idea about crystal reports. So you all please suggest the best one would be for me espcially for web based reporting.
Regards,
View 7 Replies
View Related
Nov 17, 2006
How do I fax out reports from SQL Server Reporting Services (SSRS) 2005? I tried RightFax 6.0 but it didn't work.
View 4 Replies
View Related
Jul 13, 2007
Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.
View 1 Replies
View Related
Nov 21, 2007
Hi Guys,
I am creating SSRS report using Oracle DB. When i run this query in TOAD, it's giving output but when i run this in SSRS to create new dataset then it is giving me ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle).
This is the query iam running.
SELECT ts.transaction_status_desc, COUNT (ut.transaction_id) AS transcount
FROM dsc_transaction_status_vl ts,
dsc_user_transaction ut,
billing_markets bm,
retail_location rl,
cash_register cr
WHERE ts.transaction_status = ut.transaction_status
AND ut.cr_number = cr.cr_number
AND cr.rl_number = rl.rl_number
AND ut.RL_NUMBER = rl.RL_NUMBER
AND rl.bm_code = bm.bm_code
AND (ut.creation_date BETWEEN tartDate AND :EndDate)
AND bm.bm_name IN
(CASE (:Market)
WHEN 'OKC' THEN ('OKLAHOMA CITY' || 'TULSA')
WHEN 'NFL' THEN ( 'DAYTONA'|| 'JACKSONVILL' || 'MELBOURNE'|| 'NORTH FLORIDA'|| 'ORLANDO' || 'WEST FLORIDA' )
WHEN 'LA' THEN ('PAC Los Angeles')
WHEN 'CAR' THEN ('Carolinas')
END
)
I am passing 3 parameters: StartDate, EndDate and Market.
we have 3 markets and each market includes some cities. Cities are in BM_NAME column.
My Question is that
1) How to pass parameters for Oracle using SSRS
2) How to resolve this error: ORA -01008:not all variables bound(Microsoft OLE DB provider for Oracle)
3)How can i write Stored Procedure for this query & How to execute SP in SSRS.
Please reply me. Thanks in advance.
Thanks
Santosh
View 11 Replies
View Related
May 8, 2008
Hi All,
I have a project that is already in MS Access that has many reports and I must develop the same project in .NET with SSRS for the reports. By seeing the same scenario in these forums I imported by right clicking on the project name, all the reports from Access have been imported..
My question is, that will the imported reports from MS ACCESS will be the same as that of the reports we will generate in SSRS? and can I use them as final reports. And call these reports in my .Net code..Is there any article regarding this please provide so that I can read and learn how to use that.. And for each .rdl files the data set si coming as dataset1...can we change the dataset name?..Please repond..ASAP.
Thanks
dotnetdev1
View 4 Replies
View Related
May 29, 2012
I have 100+ columns and I want to create a SSRS report which has to have dynamic columns and data. The source tables looks as below:
(First row has column names)
Formula1 Formula1_Amount Formula2 Formula2_Amount .........
Pen 1001 Pencil 100
View 1 Replies
View Related
Feb 29, 2008
I am not able to access registery key in report when report is deployed on reporting server. But when that report (.rdl) is opened in a Business Intelligence project it is able to access registry key.
So, my question is what need to be done to get value of registery key in reports deployed on reporting server.
View 3 Replies
View Related
Mar 24, 2008
Hi Folks,
I have SSRS and Asp.net2.0. i have been asked to create the dashboard reports for our organization. please give me some tips, how to develop the dashboard reports using this technology?
Is there anyother resources avilable to develop this dashboard reports? thanks in advance..
Thanks,
Senthil
View 11 Replies
View Related
Mar 11, 2008
We have 7 SSRS reports subscription which execute every night at various time intervals.
Some times, due to database unavailability subscriptions can not access the source database, so these subscriptions continuously try to connect the database. (Even after setting connection time out.)
When the database is up again, all these subscriptions create bottleneck for the database and the whole system crashes.
So we want to stop subscriptions after some time interval (lets say 2 hours after it starts),
After that time interval what ever may be the status of the subscription (processing, done or fail) it should stop.
Please let me know the solution, Thanks in advance.
View 1 Replies
View Related
May 19, 2008
I have created some reports in BIDS and saved them to a folder in my m/c (without deploying them) . i want to deploy that to the report server through C# code.
i can deploy that onto any Report Server. For that I will have to change the datasource connection string.
Is there a way to achieve this. Please let me know if it is there.
Regards...
Girija Shankar
View 5 Replies
View Related
Apr 3, 2007
I came across a website that claimed "There are approximately 116 functions in Crystal Reports that do not have a direct equivalent in VB.NET or Reporting Services (SSRS)." Does anyone know what these functions are?
View 3 Replies
View Related
May 23, 2007
Hi all,
I m new the the SQL Server Reporting Service and Blackberry Device...I want to view my SSRS ReportServer on Blackberry Device...
Is anyone know how is it possible???
Thanking you in advance...
Regards,
Balwant Patel.
View 3 Replies
View Related
Jul 23, 2007
Hi,
I need to move few folders from our DEV SSRS 2005 environment to another
server. Folders will be moved to new parent folders.
Is there any tool that I can use fot this purpose?
I used RSScripter from SQLdbatips.com. Although the tool works great but it
can't script multiple folder reports. I have to script one by one and it is
a big problem.
Thanks
Alex
View 1 Replies
View Related
Apr 29, 2015
I have a Manager dashbord report.In this report 1st page contains some tables and 2nd,3rd page contains line charts with tables.Actually what we need is in 1st page tables are pretty simple,we need to add kpi's and shown these tables in kpi. kpi in ssrs and how to add kpi in ssrs reports?
View 2 Replies
View Related
May 20, 2008
Hi All,
I want to know How to make Drill Through Reports in SSRS ?
Please Suggest.
Ritesh Kumar
View 5 Replies
View Related
Mar 13, 2007
Hi All,
In my SSRS report there is a column with email field, when the user clicks on it -- it should open the outlook and in the attachment field there should be a screenshot of that report
i think anything i could do is only in the jump to url in the navigation tab......Please suggest me the solution or any other alternatives.
Thanks in advance for help
Warm Regards,
Chanduu.
View 1 Replies
View Related
Apr 7, 2008
i'm a new developer and working with ssrs , any one can provide me by the steps of Reports Deployment and ssrs installation . i'm using sql server 2005 with asp.net ,vb.net ....
thanks
View 1 Replies
View Related
May 23, 2007
In SSRS 2005, Is it possible to have a link in one report (i.e. report A) to be directed to report B.
Can you show me guidance on where to start please?
View 3 Replies
View Related
Feb 3, 2007
Hi,
I am creating a application to show reports for daily based information.
I have created the reports and i am changing the data source at run time.In order to view the updated reports, i have to deploy.
So i need to deploy the reports automatically.
can any one gave a idea to do this.
thanks
View 6 Replies
View Related
Oct 12, 2007
Hi Experts,
I'm using SSR5 2005. I have a set of Cubes. Any idea as how to created customized reports using SSRS. The end user should be able to create reports by himself. Please help or send me some links where I can get help in this regard.
Thanks & Regards,
Naveen J V
View 4 Replies
View Related
