I have reports in report server which are accessed by url access with parameters.
When the report is generated the whole url string is displayed in the adress bar with parameters. Is there any way to prevent the user to change the parameter value?
Any ider whould be very appreciated!
You could use a html form and use POST instead of using GET via the url.
See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=301748&SiteID=1
Are you using winforms or webforms?
With the winforms ReportViewer control, you can use the RenderingComplete event.
If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.
|||Thanks for that Brian.
Yes , am using a winform with a report viewer control.
i'll give a try using "RenderingComplete" event.
Thanks for your help
|||Hi prk,
i wanted a help from u, how are u uploading files to the reporting server.
i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.
I am new to .NET technology. if u have any samples with SOAP API please send it to me
sureshk@.dcons.com / sureshbabu_krish@.yahoo.com
|||Thanks Brian
That worked nicely :)
|||Sureshonce you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm
following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx
let me know how you are going with this.
Best of luck
Are you using winforms or webforms?
With the winforms ReportViewer control, you can use the RenderingComplete event.
If you are using webforms, there is no client side event that exposes this information I have not tried, but it might be possible to determine when the page finishes loading using the body onload event.
|||Thanks for that Brian.
Yes , am using a winform with a report viewer control.
i'll give a try using "RenderingComplete" event.
Thanks for your help
|||Hi prk,
i wanted a help from u, how are u uploading files to the reporting server.
i wanted it to programmatically instead of manual upload, all the help from this FORUM i got is that, i should use SOAP API. which i am not able to do it.
I am new to .NET technology. if u have any samples with SOAP API please send it to me
sureshk@.dcons.com / sureshbabu_krish@.yahoo.com
|||Thanks Brian
That worked nicely :)
|||Sureshonce you add web reference now you can access report server within ur .net app.
check following examples in books online
ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.SQL.v2005.en/samp9/html/33e026d8-3750-436f-a5aa-1d5f98a41eef.htm
following should help you in what u want. it talks abt how to add reports to report server programmatically
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createreport.aspx
let me know how you are going with this.
Best of luck|||
Hi;
I am working on report view of a web form. I am looking for some event can fire after a report rendering. I only find a RendingComplete event of report viewer in a window form. But I could not find a similarly enent in the web form. Could some one help me?
Jennifer Xu
Since i have 5 different projects all has the same kind of reports., but calling via 5 different sites all sites on same webserver.
The problem i have is the .rds file name is same in all 5 report projects and it is a shared datasource., now when i compile the report project it will not load or overwrite the .rds file since the name is same, for that reason i tried to have the .rds file in reports folder as a datasource not a shared datasource. but i tried to add it, after i create the datasource, it is automatically going into the shared datasource folder, how can i create a datasource not shared under reports folder.
Thank you very much for all your help and information.
Hello,
From the Project menu, select 'Properties'. In the TargetDataSourceFolder, type the path of where you want the data source to go. From Books Online:
Type the name of the destination folder for publishing the shared data sources that are contained within the project. This value is optional. If you do not specify a folder, the data source is published to the same folder as the report. If the folder does not exist on the report server, Report Designer creates the folder when the reports are published. If a folder is located within another folder, include the path to the folder, starting at the root, for example, Folder1/Folder2/Folder3.
Hope this helps.
Jarret
|||Thank you very much Jarret.....Hi,
I have a sproc that returns somevalues and everything is working fine... and in my reports i am assigning the header data (in a detail column) based on the some feilds in the sproc... and there around 20 feilds that i want to show... but at a given time i am pretty sure that there wont be more than 10 fields that will have data.
So is it possible that show only the columns that have data in it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths of the column in those tables without shrinking the size of the Table...
any help is appreciated..
Regards
Karen
Hi,
So is it possible that show only the columns that have data in it and sometimes if there is less that 5 - 6 fields.. i want to realign the widths of the column in those tables without shrinking the size of the Table...
If there's no record in one of your row, you can use =IsNothing(Fields!productname.Value) filter your record. But if you want to hide the column that has no data, I suggest you to handle these works in your data accessing modular. For example, if you check one of your column is empty, just remove the column in your record set, so the column would not show in the report.
Thanks.
Jin,
Thanks for your response.. what do u mean by remove the column from the recordset... cause i am populating the Reports using a stored procedure and sometimes... there may be some data or not..
Can u pls give me code snipet or an example
Regards
Karen
|||Hi,
if you check one of your column is empty, just remove the column in your record set, so the column would not show in the report.
Here's the sample code, suppose you have two fields, Sp and Hd. If there's no data in Hd field of your return set, then only Sp field would been selected.
DECLARE @.NULLCOUNTINTSELECT @.NULLCOUNT =COUNT(*)FROM MatrixCapitalWHERE MatrixCapital.Spisnot nullif @.NULLCOUNT=0BEGIN SELECT MatrixCapital.HdFROM MatrixCapitalEND ELSEBEGIN SELECT MatrixCapital.Hd,MatrixCapital.SpFROM MatrixCapitalENDThanks.|||
Jin,
Thanks a lot for your answer so this mean that if i have more 5 - 6 columns NULL... i have check for each column in the NULL count and then prob union for each feild so that my end resultset will be columns that has data in them?
I have another question too.. if i have a table variable like
Declare @.tbl table
(
tblid int indentity(1,1),
Col 1,
Col 2,
..,
Col n
)
Is it possible to have a variable column size depending on the number of entries in my select column like for example.. my if i have 10 columns in my select statement and in that 5 are null... so can just insert 5 rows to the table and then remove the remaining columns out.
Regards
Karen
|||
Hi,
i have check for each column in the NULL count and then prob union for each feild so that my end resultset will be columns that has data in them?
Yes, that's right.
Is it possible to have a variable column size depending on the number of entries in my select column like for example..
Based on my knowledge, another way i can see is to use CASE WHEN clause in your SQL, but it still requires you to give differrent sql statments accoring to the "isNUll" result of a column.
Thanks.
sqlI am searching through forums but cannot find the answer.
I have reports on the Intranet.I do not need to restrict it.Everyone should be able to see everything.The problem is that if I assign anonymous access to the reporting server, I cannot manage it.Whatever I do, it would give me an error message saying that account IUSR_SERVER has not rights to do anything.
I cannot use form authentication because I send parameters using url.
Any solution that I could use?
Can I create a user that has restricted access to reporting and use authentication using url?
Any other ideas?
Thank you.
Igor L. Kravchenko.
You need to give IUSR_SERVER Report Server permissions, but know that once you allow Anonymous Access, EVERYONE is seen as IUSR_SERVER, and will get the corresponding Report Server permissions.|||Thank you for your reply.
I understand that everyone will be able to see all reports but I do not care.
I gave IUSR_SERVER permissions on the server and it works. The problem is that, in this case, it does not allow me to manage it.
What to do, so I could manage my reports?
Thank you.
Igor Kravchenko.
|||If you give IUSR_SERVER the Content Manager role on Home and the System Administrator role at the system level, everyone will be able to manage the Report Server.|||I understand it.
Is there any way that I can login as someone who can do it when eveyone else could not do it?
Thank you.
Igor Kravchenko.
Hi,
I'm a newbie to reporting service.
I deployed a report on the server. When I viewed it on the server by entering the URL of http://localhost/reports$SQLExpress, everything's fine. When I tried to view it form a client machine on http://MyServerName/reports$SQLExpress, it failed. I did assign a role to the client user. I'm just wondering whether it is possible to do this.
I'm using SQL Express, the server runs win2003 server and the client machine runs winXP.
What was the error message? What authentication method are you using for reporting services?
sluggy
|||The error message was"The page cannot be displayed. The page you are looking for is currently unavaiable. blah...blah...".
I use Windows authentication for reporting service. Thanks!
|||You are probably hitting the double-hop problem with IIS
http://blogs.msdn.com/jgalla/archive/2006/03/16/553314.aspx
The fix is to store the credentials for accessing the datasource in the report server.
I have found a lot of comments on the net but nowhere was I able to have a direct answer to this question:
My client has a complex database deployed on SQL Server 2000. He wishes to create reports based on this data using SSRS. Another division of the same company just implemented SQL Server 2005 and SSRS 2005.
I wish to know if SSRS 2005 is able to create reports based on data from SQL Server 2000?
Thank you.
S
Sure. You'll have no problems reporting against 2005 and 2000 together...
I have a requirement to create dynamic reports for my client.
once i create these reports then the user will choose columns of there choice.
so the columns may belong to multiple tables.
Now the report should get generated with the layout etc. is it possible.
since our project is totally on the webserver(webbased.)
please if you can provide me with any links with dynamic report creation wizards.
and also we only use Stored procedures via database.
which is best is writing the entire queries right behind the layouit or calling the entire logic via Stored procedure. i am a bit confused. this is my first project working on reports itself.
Thank you all for the helpful information.
Sounds like you need to generate the report definitions programatically. The RDL Object Model code sample in this download should help.sqlI need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
sqlI need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
I need to be able to create a bar code in SQL reports. Do I need to get a three party tool or do you have anything that can help.
Thanks
SQL Server Report needs nothing. What you need it's a font. You have to look for a ttf with eg bar code 39 or other encoding. Unfortunattly goods ttf aren't free.I found a better choice instead of using fonts.
Barcode Professional .NET for Reporting Services
http://www.neodynamic.com/Products/BCRS/BarcodeRS.aspx?tabid=78&prodid=7
Cheers
|||Or you could try this Windows Form Control that supports Reporting Services.
http://www.technoriversoft.com/developer.html
|||Hi, I am trying to use a TTF font, and it prints out but the bar code reader is not reading the font.
In Crystal, I had to put an * before after the value.
In Excel, it works the same way.
But in SRS 2000, it will not work.
My expression is
="*"& Fields!MANUFACTUREORDER_I.Value.Trim() & "*"
I have also tried using the plus instead of *.
The font I am using is Free 3 of 9 Extended.
thanks for you help.
|||
IT is not good way
it is because when you compile the report into production server.
when user print it, it will show the text rather than bar code....
|||As Inamori has stated. Everything works fine until the report is compiled into a productions server. At that point the barcode is shown as clear text.
So what exactly is the fix. Was one ever found?
I have a .NET Web application that points to quite a few SQL reports.
Here is what I am looking to do:
I have a list of values that will change quite frequently. Say this is the list for example
A
B
C
D
E
In my report I need to say "where MyField = 'A' OR MyField = 'B' OR MyField = 'C'" .... etc.
The problem here is the list above is going to vary in value and *in number of parameters*. It won't always be 5 parameters...sometimes 6, etc. I won't know at compile time how many parameters.
***Is there a way to build the query for the Report in Visual Studio and have the report use that query for its dataset?***
Basically in Visual Studio I would say:
myQuery = "select whatever from wherever where MyField = FirstListValue "
While not at end of list
myQuery += "OR" + nextValue
End While
Has anyone done this before?
Are you using SQL Server 2005 and are you saying that it is a different number of values that can be in the same field? If so, just us a multi value parameter and in your SQL in the report add the clause: and MyField in (@.MyParm)
Then pass the values to the report in the MyParm parameter.
|||I'm fairly sure that is what I need. I'll give it a try and let you know how it turns out. Thanks!