Can Reports Be Created In SSRS-2005 Using VB Or VB.NET
Mar 31, 2008View 6 Replies
ADVERTISEMENT
Can I Write SSRS 2008 Reports To Run On SQL 2005 SSRS?
Sep 12, 2007Is 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
Can I Use Reporting Services 2005 Reports On An ASP.NET Page Created With Visual Studio 2003?
Oct 15, 2007Hello,
I've seen this question floating around, but I have not been able to find a definitive answer.
Can this be done, and if so, what do I need to install into Visual Studio 2003?
Thank you.
-Gumbatman
How To Fax Reports From SSRS 2005
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.
Migrate SSRS 2005 Reports
Jul 23, 2007Hi,
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
SSRS 2005 Link Reports
May 23, 2007In 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?
Sql Server 2005 SP2 Affect SSRS Reports.
Mar 19, 2008Hi,
I had a report (.rdl) using sql reporting services in sql server 2005, where it was running quite good.
I have just installed sql server 2005 sp2. After that, when I run the report through report viewer, the result of the report contains the first record of the dataset keep on repeating for all other records. If I run the dataset the results are correct,but if I preview it, then the first record alone repeating for all other records.
I feel that sp2 might cause this rendering problem. Any suggestion please?
Murali.
Converting Reports FROM SQL RS 2000 TO SSRS 2005
Apr 23, 2007I 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.
Cannot View Reports After Upgrading To SSRS 2005
Aug 29, 2007Hello,
We recently did an "in place" upgrade of SQL Server and SSRS 2000 to 2005.
After the upgrade we cannot view the exisiting reports. (although we can publish new reports using the VS2005 Designer and they show up just fine.)
We have SP2 installed for SSRS2005 and all SPs for SQL are up to date.
When we navigate to an existing report via the reporting services website, the report acts like it is trying to run and then returns and error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
When we look at the logs we see that the report server cannot initialize the stream from the Catalog table.
aspnet_wp!library!1!08/28/2007-16:52:29:: Call to GetPropertiesAction(/Report Administration/All Process Dates, PathBased).
aspnet_wp!chunks!1!08/28/2007-16:52:29:: i INFO: Returning old chunk for: (fd690975-ec5b-4033-9664-81335e3990c0, 'CompiledDefinition', 0)
aspnet_wp!library!1!08/28/2007-16:52:29:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., Could not initialize stream;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: i INFO: Exception dumped to: C:Program FilesMicrosoft SQL ServerMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson
aspnet_wp!chunks!1!08/28/2007-16:53:01:: e ERROR: ### SnapshotConverter(fd690975-ec5b-4033-9664-81335e3990c0, True), Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!1!08/28/2007-16:53:01:: Call to GetSystemPropertiesAction()
We welcome any suggestions.
Migrating RS 2000 Reports To SSRS 2005
Jan 8, 2007Hi,
Can anyone point me to any reference material, resources etc. on migration of SQL Server 2000 Reports to 2005?
Thanks,
Dave
Sql 2005 Standard Advice SSRS Crystal Reports
Mar 24, 2008I have visual studio 2008 on my vista ultimate machine. I also have sql express edition, however I have no installed it
I was thinking of installing sql standard edition because I really am interested in development of ssrs,
crystal reports in a commercial development. Is it best to have both sql express and the standard edition
I am excited about sql 2008. What is the best configuaration for an aspiring small comercial developer
like myself. I am looking for input. Thanks
SSRS 2005 - Server Error In '/Reports' Application.
Oct 18, 2006When trying to open the reports server \servername
eports we are getting an error page titled "Server Error in '/Reports' Application." The server has been restarted, and as this is a new deployment, there has been very little access for individuals to make changes.
Any ideas on how to resolve the problem?
Thanks in advace
Error While Viewing Reports Unable To Locate Control SSRS 2005: OReportCell
Apr 30, 2007Hello Friends,
I have created few reports in SSRS 2005 on Windows 2003 Standard. Previouly I was not able to view reports from my .ASPX page which contained a ReportViewer, after going throuhg some other threads I was able to create a snap-shot for my reports . But still I'm not able to view reports, each time I try to view the page I get a message box with a error as : "Unable to locate control SSRS 2005: oReportCell" the same error is displayed when i try to access my reports from "http://localhost/reports.....".
But the funny thing is I'm able to view the reports when I use the following URL: "http://localhost/reportserver/pages/reportviewer.aspx?/<report>". I have applied all the Hotfixes & installed the latest Service packs. Any suggestions ???????
Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008I 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
Reports Usage Frequency For All The Existing Reports On SSRS 2000
Mar 18, 2008I 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
Converting Crystal Reports To SSRS Reports
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
(very Newb) Created A Legend For Reports But................
May 7, 2008.......I need to know how to have that displayed before the reports are ran. I'd like to have in the Report Parameters area so users can see this information when making choices for the reports.
View 1 Replies View RelatedTemp Table Created In The SSMS,but SSRS Gives Error
Feb 8, 2008Hi ALL,
The sub report has stored procedure which uses ##temp table,to get it's results.
Stored procedure code is:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER OFF
GO
ALTER PROCEDURE [dbo].[rpt_FAP_Profile_claim] @TABLE_NM varchar(50),@MBR_ID varchar(50)
AS
SET NOCOUNT ON
DECLARE @SQL_TXT varchar(8000)
SET @SQL_TXT = ' SELECT * FROM STEP_PROFILE_CLAIM_' + @TABLE_NM + ' c WHERE c.MBR_ID = '''+ @MBR_ID + ''''
--SET @SQL_TXT = 'SELECT TOP 100 * FROM CLAIM'
EXEC(@SQL_TXT)
When I run this in SSMS gives error::-
Msg 208, Level 16, State 1, Line 1
Invalid object name 'STEP_PROFILE_CLAIM_765032'.
(1 row(s) affected)
How do I make it work and get the result in my sub report.Is any properties needs to be set in the SSMS or SSRS sub report or any other modificatons?.Or is some thing wrong in the temp table?.Plz help.
Thanks in advance.
Created View In Sql Management Studio Not Showing In Ssrs
Mar 17, 2008hi all
Using Sql Server 2005 / Reporting Services
I created a view in sql server management Studio but can't see it in Reporting Services.
I appear to have the same security permissions?
what else am I missing?
thanks
jewel
Rename Tabs In Excel File Created By SSRS
Nov 13, 2007
I love SQL Server Reporting Services (SSRS), but it doesnt let me name the tabs when exporting to Excel. The feature is well documented as not being available.
So I figured I can use the cell(1,1) on each tab to contain the tab name, and have an SSIS job poll a file share, open the file, read the cell, rename tabs, rename the file, and then email out the file. Polling the directory and emailing is a piece of cake, but I can't find any way to rename a tab without having Excel loaded on the SERVER. Not to mention instantiating an entire instance of Excel on the SERVER every time I want to do this.
I want to leverage SSRS, and preserve the formatting of the excel file, which is why I don't just dump the data in with SSIS to begin with.
Anybody have any ideas?
SSRS How To Customize The Report Models Created For Specific Users
Jan 3, 2008hi,
I am new to SSRS. I am doing some report models for Ad-hoc reports. Im my database i have some users and their roles according to my requirement. User should only see the particular reports if he have privilege. how to customize...
User will access Report Builder to do adhoc report.
For example
I have 5 report Models
rptModel1
rptModel2
rptModel3
rptModel4
rptModel5
In my data base there are 3 users.
user1 have privilege to view rptModel1, rptModel3
user2 have privilege to view rptModel4, rptModel5
user3 have privilege to view rptModel2, rptModel5
When Particular user access the report builder, There i want to show only that particular Report models...
is there any posibilities to do this please Help me.
Thanks in Advance...
-Kannan
kannan1017@gmail.com
SSRS Or Crystal Reports
Feb 19, 2008Hello 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,
SSRS Vs. Crystal Reports
Jul 13, 2007Hi, all. Does Microsoft provide a document comparing SSRS against Crystal Reports? Thanks.
View 1 Replies View RelatedSSRS Reports With Oracle DB--some One Plz Help Me.
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
Access Reports To SSRS
May 8, 2008Hi 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
Migration Of SQL Reports 2000 To SQL Reports 2005
Feb 13, 2008Hi 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
Dynamic Columns In SSRS Reports
May 29, 2012I 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
Accessing Registery Key In SSRS Reports
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.
How To Create Dashboard Reports Using SSRS?
Mar 24, 2008Hi 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
How To Stop SSRS Reports Subscriptions
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.
Deploying Reports From SSRS Project
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
Converting Crystal Reports To SSRS
Apr 3, 2007I 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 RelatedSSRS Reports On Blackberry Device...
May 23, 2007Hi 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.