Dear all
I want to display three tables on one report. This works fine as long I
place them on the same horizontal line (3 columns). If I use 2 columns (first
column table 1, second column tables 2 and 3) I have the problem, that table
3 starts where table 1 ends. Because table 1 is longer as table 2 I have a
lot of empty space between table 2 and 3.
How can I change this?
Thanks for your answer,
MarcWell, I have a workaround: I use a subreport.
Regards, Marc|||Marc,
I am not sure what you are trying to do, but I have several reports that
need multiple tables on one report. I have had to put them within nested
list boxes at times to get a particular order of the tables to appear (since
otherwise then tend to follow one after the other and I wanted them
interlaced) - In other cases I have used rectangles to enforce placement
within a page. There are other ways to handle without a subreport. If you
give a better idea of what you want then maybe I can suggest something.
Thanks
"Marc" wrote:
> Well, I have a workaround: I use a subreport.
> Regards, Marc|||Hi MJT
Thanks for your answer. Well I'm quite new to SQL Server 2005 Reporting
Services so I struggled with placing tables on a report and arranging them as
the requirement says. Like you proposed I useed the rectangle - this works
very well! What I did not understand is the List component. When I place
several tables inside a List, this component requires a dataset. So I guess
the List is used for other purposes.
Best regards,
Marc|||Hi Marc,
A list data region repeats with each group or row in the dataset. A list
can be used for free-form reports or in conjunction with other data regions.
You could refer the following article in the SQL Books Online:
Working with List Data Regions
http://msdn2.microsoft.com/en-us/library/ms159121(d=ide).aspx
Hope this will be helpful to you to understand the List Control. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.sql
Showing posts with label report. Show all posts
Showing posts with label report. Show all posts
Tuesday, March 20, 2012
3 Questions
1. The printing orientation of crystal report can be set from File --> Printer Setup
My report is set as landscape. I indicate the print mode to be activeX in the Jsp code.
However, when the activeX prompts out, I have to choose a printer and also set the page to be landscape again.
Can I skip the step telling the printer to print landscape?
2. When the activeX prompts out, it is set to Page 1 of N by default, How can I change the default setting to print All pages?
3. The language of a browser can be set from Internet Option --> Languages (in Internet Explorer)
Ive found that the activeX displays nothing if the language of browser is not set as English.
We dont want the user to change the language setting in browser, but how can we display the
activeX properly if the language is originally be chinese?(1) CR.EnablePopupMenu = False
My report is set as landscape. I indicate the print mode to be activeX in the Jsp code.
However, when the activeX prompts out, I have to choose a printer and also set the page to be landscape again.
Can I skip the step telling the printer to print landscape?
2. When the activeX prompts out, it is set to Page 1 of N by default, How can I change the default setting to print All pages?
3. The language of a browser can be set from Internet Option --> Languages (in Internet Explorer)
Ive found that the activeX displays nothing if the language of browser is not set as English.
We dont want the user to change the language setting in browser, but how can we display the
activeX properly if the language is originally be chinese?(1) CR.EnablePopupMenu = False
3 different computers problem...
hi all,
situation is:
report server and sql server installed in computer a
iis server, vs.net installed in computer b
i have try many ways including setting credentails, IIS setting, web.config
etc but still got access denied error when using render() functions...
could anyone can advise me the procedure of checking the setting of computer
a and b starting from the beginning?cos i dun really know, where is the
problem.
thank you very much in advance.I think you have to do the RS installation on Web server. Just show the RS
databases on the SQL Server.
"Jasonymk" wrote:
> hi all,
> situation is:
> report server and sql server installed in computer a
> iis server, vs.net installed in computer b
> i have try many ways including setting credentails, IIS setting, web.config
> etc but still got access denied error when using render() functions...
> could anyone can advise me the procedure of checking the setting of computer
> a and b starting from the beginning?cos i dun really know, where is the
> problem.
> thank you very much in advance.
>sql
situation is:
report server and sql server installed in computer a
iis server, vs.net installed in computer b
i have try many ways including setting credentails, IIS setting, web.config
etc but still got access denied error when using render() functions...
could anyone can advise me the procedure of checking the setting of computer
a and b starting from the beginning?cos i dun really know, where is the
problem.
thank you very much in advance.I think you have to do the RS installation on Web server. Just show the RS
databases on the SQL Server.
"Jasonymk" wrote:
> hi all,
> situation is:
> report server and sql server installed in computer a
> iis server, vs.net installed in computer b
> i have try many ways including setting credentails, IIS setting, web.config
> etc but still got access denied error when using render() functions...
> could anyone can advise me the procedure of checking the setting of computer
> a and b starting from the beginning?cos i dun really know, where is the
> problem.
> thank you very much in advance.
>sql
3 CrossTabs
I need to insert 3 Cross Tabs into the same report, each has to use a different filter. I can create a filter on my first crosstab, however I cannot do it on the other 2. All 3 are using the same field has a filter, however based on the value in that field it determines what data will be used by the particuliar crosstab. Any help given is greatly appreciated.If i understood your question correctly, the suggested answer would be to create different groups or if that is not possible create a formula in the section expert that says to display the cross_tab only if a certain value is found.
Hope it helps
Cheers
Milos
Hope it helps
Cheers
Milos
Monday, March 19, 2012
2nd Table on Report Shifts Down
Hi
I have created a report with in reporting services with 2 tables. One at the top of the page, and one at the bottom. The one at the top will contain payment details which grows depending on how many items(rows) are in my dataset and the table at the bottom contains a cheque layout - for ex. Pay Mr X, Date...etc. This table will fill out boxes on a cheque
My problem is that the table at the bottom(cheque) is being shifted down depending on what's in the top table(payment items). I need that the cheque table remain in the sample position, independent from what is in the payment table.
Has anybody ever encountered this problem and have a solution to it?
Thanks in advance.Hi
managed to solve this problem using Sub Reports. I put the top table into a sub report and it works fine.
The only problem is when adding another level of grouping in the Table within the sub report, the initial problem emerges again.
Any other ideas?
|||Try putting the table inside of a rectangle (invisible border). The table should "consume" the space in the containing rectangle before pushing the other table down. However, there is no guarantee that the bottom table will stay on the page if the top grows too much.
2nd request: group visibility issue
Hi,
I have a report with a SP datasource. The groups have drilldown
capabilities. I have conditional expressions on groups 1 and group 2 that
when a flag in the proc is one value then something like this is displayed:
region 1
district 1
facility A data data data
facility C data data data
facility F data data data
district 2
facility B
facility D
...etc
Then, when the flag is another value, I want to display just the facility
list without the groups. I almost have this successfully implemented, by
having conditionals on groups 1 and 2. It is something like this:
=iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
The only problem is that when I disable the groups like that, I still get
the drilldown's plus sign at the top of the facility list.
+
+
Facility A data data
Facility B data data
etc
I don't want them there. Hope this is clear.
Thanks
--
Patrick StadlerYou cannot conditionally "remove" groupings.
You may try duplicating the table/matrix and remove the groupings for the
copied data region. Depending on the parameter values you would always just
show one of the data regions.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stads" <Stads@.discussions.microsoft.com> wrote in message
news:F4FCE3A3-1389-4F00-AB4F-BE3BBDB6A519@.microsoft.com...
> Hi,
> I have a report with a SP datasource. The groups have drilldown
> capabilities. I have conditional expressions on groups 1 and group 2 that
> when a flag in the proc is one value then something like this is
displayed:
> region 1
> district 1
> facility A data data data
> facility C data data data
> facility F data data data
> district 2
> facility B
> facility D
> ...etc
> Then, when the flag is another value, I want to display just the facility
> list without the groups. I almost have this successfully implemented, by
> having conditionals on groups 1 and 2. It is something like this:
> =iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
> The only problem is that when I disable the groups like that, I still get
> the drilldown's plus sign at the top of the facility list.
> +
> +
> Facility A data data
> Facility B data data
> etc
> I don't want them there. Hope this is clear.
> Thanks
> --
> Patrick Stadler
I have a report with a SP datasource. The groups have drilldown
capabilities. I have conditional expressions on groups 1 and group 2 that
when a flag in the proc is one value then something like this is displayed:
region 1
district 1
facility A data data data
facility C data data data
facility F data data data
district 2
facility B
facility D
...etc
Then, when the flag is another value, I want to display just the facility
list without the groups. I almost have this successfully implemented, by
having conditionals on groups 1 and 2. It is something like this:
=iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
The only problem is that when I disable the groups like that, I still get
the drilldown's plus sign at the top of the facility list.
+
+
Facility A data data
Facility B data data
etc
I don't want them there. Hope this is clear.
Thanks
--
Patrick StadlerYou cannot conditionally "remove" groupings.
You may try duplicating the table/matrix and remove the groupings for the
copied data region. Depending on the parameter values you would always just
show one of the data regions.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stads" <Stads@.discussions.microsoft.com> wrote in message
news:F4FCE3A3-1389-4F00-AB4F-BE3BBDB6A519@.microsoft.com...
> Hi,
> I have a report with a SP datasource. The groups have drilldown
> capabilities. I have conditional expressions on groups 1 and group 2 that
> when a flag in the proc is one value then something like this is
displayed:
> region 1
> district 1
> facility A data data data
> facility C data data data
> facility F data data data
> district 2
> facility B
> facility D
> ...etc
> Then, when the flag is another value, I want to display just the facility
> list without the groups. I almost have this successfully implemented, by
> having conditionals on groups 1 and 2. It is something like this:
> =iif(Fields!GroupRegDis.Value = 1, Fields!districtName.Value, 0)
> The only problem is that when I disable the groups like that, I still get
> the drilldown's plus sign at the top of the facility list.
> +
> +
> Facility A data data
> Facility B data data
> etc
> I don't want them there. Hope this is clear.
> Thanks
> --
> Patrick Stadler
2nd POST-How to change color for a visited field?
Hello All,
I have a parameterized report (Report1), which has a field (say
'Control#')that has 'Jump to Report' navigation property setup. When the
user selects their parameters, Report1 displays, say 10 records displayed on
the Report, and when the user clicks on Control# of Report1, it Jumps to
Report2, which displays the details of that Control#. say from 10 records
displayed on Report1 the user cliked on the 5th record to get Report2. after
reviewing that Report, the user would like to go back to Report1. Here, I
want to change the font color of the 5th record Control#, as I have already
viewed it. By doing this, I would be able to make out, which records I
reviewed and which ones I did not. Is there any built in functionality in the
RS to do? Could please someone help me'
Greatly appreciated!There is no built-in feature in RS to magically display the visited field.
Instead, I would log the user visited fields history in the database using
the User!UserId. So, when the user navigates from Report1 to Report 2
(assuming that you pass Control# as parameter) I would base Report 2 on a
stored procedure which will log an entry for that user. Then, the user goes
back to Report 1 you will just need to link the dataset with the visited
history table using User!UserId. Of course, you need at some point to clear
the history, e.g by scheduling a job with the SQL Agent.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"amma" <amma@.discussions.microsoft.com> wrote in message
news:EDBB4673-4C72-4609-A6EE-106E785653AD@.microsoft.com...
> Hello All,
> I have a parameterized report (Report1), which has a field (say
> 'Control#')that has 'Jump to Report' navigation property setup. When the
> user selects their parameters, Report1 displays, say 10 records displayed
on
> the Report, and when the user clicks on Control# of Report1, it Jumps to
> Report2, which displays the details of that Control#. say from 10 records
> displayed on Report1 the user cliked on the 5th record to get Report2.
after
> reviewing that Report, the user would like to go back to Report1. Here, I
> want to change the font color of the 5th record Control#, as I have
already
> viewed it. By doing this, I would be able to make out, which records I
> reviewed and which ones I did not. Is there any built in functionality in
the
> RS to do? Could please someone help me'
> Greatly appreciated!
>
>
I have a parameterized report (Report1), which has a field (say
'Control#')that has 'Jump to Report' navigation property setup. When the
user selects their parameters, Report1 displays, say 10 records displayed on
the Report, and when the user clicks on Control# of Report1, it Jumps to
Report2, which displays the details of that Control#. say from 10 records
displayed on Report1 the user cliked on the 5th record to get Report2. after
reviewing that Report, the user would like to go back to Report1. Here, I
want to change the font color of the 5th record Control#, as I have already
viewed it. By doing this, I would be able to make out, which records I
reviewed and which ones I did not. Is there any built in functionality in the
RS to do? Could please someone help me'
Greatly appreciated!There is no built-in feature in RS to magically display the visited field.
Instead, I would log the user visited fields history in the database using
the User!UserId. So, when the user navigates from Report1 to Report 2
(assuming that you pass Control# as parameter) I would base Report 2 on a
stored procedure which will log an entry for that user. Then, the user goes
back to Report 1 you will just need to link the dataset with the visited
history table using User!UserId. Of course, you need at some point to clear
the history, e.g by scheduling a job with the SQL Agent.
--
Hope this helps.
----
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"amma" <amma@.discussions.microsoft.com> wrote in message
news:EDBB4673-4C72-4609-A6EE-106E785653AD@.microsoft.com...
> Hello All,
> I have a parameterized report (Report1), which has a field (say
> 'Control#')that has 'Jump to Report' navigation property setup. When the
> user selects their parameters, Report1 displays, say 10 records displayed
on
> the Report, and when the user clicks on Control# of Report1, it Jumps to
> Report2, which displays the details of that Control#. say from 10 records
> displayed on Report1 the user cliked on the 5th record to get Report2.
after
> reviewing that Report, the user would like to go back to Report1. Here, I
> want to change the font color of the 5th record Control#, as I have
already
> viewed it. By doing this, I would be able to make out, which records I
> reviewed and which ones I did not. Is there any built in functionality in
the
> RS to do? Could please someone help me'
> Greatly appreciated!
>
>
2nd Post Re: Subreport Shifts in HTML view...
I have inserted a linked subreport into a table. I have it formatted so
that it lines up perfectly with my main report, so the user shouldn't even
be able to tell that it is a subreport. When I render the report in the
.Net viewer, it's columns line up perfectly. When I export to .PDF, it
lines up fine as well. But when I run the report from Report Manager,
viewing in the default HTML view or export to Web Archive, the columns shift
like 25 pts to the left. What's up with that? Is there a way to fix it?
Thanks,
LisaHave you apready tried playing with the Padding?
"Lisa" wrote:
> I have inserted a linked subreport into a table. I have it formatted so
> that it lines up perfectly with my main report, so the user shouldn't even
> be able to tell that it is a subreport. When I render the report in the
> ..Net viewer, it's columns line up perfectly. When I export to .PDF, it
> lines up fine as well. But when I run the report from Report Manager,
> viewing in the default HTML view or export to Web Archive, the columns shift
> like 25 pts to the left. What's up with that? Is there a way to fix it?
> Thanks,
> Lisa
>
>|||I have tried that. If I pad it enough where it lines up in the HTML default
view, then it ends up off alignment in the other direction in all the other
formats.
This default HTML view is killing me. It seems like there are so many
tweaky problems with it. I just wish the default looked like my view in
Visual Studio. That would make things so much easier!
Lisa
"Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
message news:24866FD7-34E1-4188-A3B3-8E4465610A25@.microsoft.com...
> Have you apready tried playing with the Padding?
> "Lisa" wrote:
> > I have inserted a linked subreport into a table. I have it formatted so
> > that it lines up perfectly with my main report, so the user shouldn't
even
> > be able to tell that it is a subreport. When I render the report in the
> > ..Net viewer, it's columns line up perfectly. When I export to .PDF, it
> > lines up fine as well. But when I run the report from Report Manager,
> > viewing in the default HTML view or export to Web Archive, the columns
shift
> > like 25 pts to the left. What's up with that? Is there a way to fix
it?
> >
> > Thanks,
> >
> > Lisa
> >
> >
> >
that it lines up perfectly with my main report, so the user shouldn't even
be able to tell that it is a subreport. When I render the report in the
.Net viewer, it's columns line up perfectly. When I export to .PDF, it
lines up fine as well. But when I run the report from Report Manager,
viewing in the default HTML view or export to Web Archive, the columns shift
like 25 pts to the left. What's up with that? Is there a way to fix it?
Thanks,
LisaHave you apready tried playing with the Padding?
"Lisa" wrote:
> I have inserted a linked subreport into a table. I have it formatted so
> that it lines up perfectly with my main report, so the user shouldn't even
> be able to tell that it is a subreport. When I render the report in the
> ..Net viewer, it's columns line up perfectly. When I export to .PDF, it
> lines up fine as well. But when I run the report from Report Manager,
> viewing in the default HTML view or export to Web Archive, the columns shift
> like 25 pts to the left. What's up with that? Is there a way to fix it?
> Thanks,
> Lisa
>
>|||I have tried that. If I pad it enough where it lines up in the HTML default
view, then it ends up off alignment in the other direction in all the other
formats.
This default HTML view is killing me. It seems like there are so many
tweaky problems with it. I just wish the default looked like my view in
Visual Studio. That would make things so much easier!
Lisa
"Rob 'Spike' Stevens" <RobSpikeStevens@.discussions.microsoft.com> wrote in
message news:24866FD7-34E1-4188-A3B3-8E4465610A25@.microsoft.com...
> Have you apready tried playing with the Padding?
> "Lisa" wrote:
> > I have inserted a linked subreport into a table. I have it formatted so
> > that it lines up perfectly with my main report, so the user shouldn't
even
> > be able to tell that it is a subreport. When I render the report in the
> > ..Net viewer, it's columns line up perfectly. When I export to .PDF, it
> > lines up fine as well. But when I run the report from Report Manager,
> > viewing in the default HTML view or export to Web Archive, the columns
shift
> > like 25 pts to the left. What's up with that? Is there a way to fix
it?
> >
> > Thanks,
> >
> > Lisa
> >
> >
> >
Sunday, March 11, 2012
2k5: Interactive Sort - Total Line moving
When using the interactive column sort in a table, I have one report that the
Total (footer) actually moves with the interactive sort. How can I keep the
footer fixed as the footer?
--
Steve Funk
Application Developer
iHomeowners, Inc.Cancel this request. This report called a proc which I was not farmiliar
with and the stored proc sent over a calculated total line at the bottom of
the rows. The report footer was not being used.
--
Steve Funk
Application Developer
iHomeowners, Inc.
"Steve Funk" wrote:
> When using the interactive column sort in a table, I have one report that the
> Total (footer) actually moves with the interactive sort. How can I keep the
> footer fixed as the footer?
> --
> Steve Funk
> Application Developer
> iHomeowners, Inc.
Total (footer) actually moves with the interactive sort. How can I keep the
footer fixed as the footer?
--
Steve Funk
Application Developer
iHomeowners, Inc.Cancel this request. This report called a proc which I was not farmiliar
with and the stored proc sent over a calculated total line at the bottom of
the rows. The report footer was not being used.
--
Steve Funk
Application Developer
iHomeowners, Inc.
"Steve Funk" wrote:
> When using the interactive column sort in a table, I have one report that the
> Total (footer) actually moves with the interactive sort. How can I keep the
> footer fixed as the footer?
> --
> Steve Funk
> Application Developer
> iHomeowners, Inc.
Thursday, March 8, 2012
2147190908 Failed to export the report
Hi All,
Facing an issue while exporting a report(invoice) to PDF in Crystal 8.5 after exporting 1000's of files(invoices) to PDF.
Error msg "2147190908 Failed to export the report". after generating this error, OKB PDF file is generated and we are nt getting any invoices from then.
We have a Licensed Copy of Crystal Reports 8.5 Developer Version
We are facing a Problem while exporting our Invoices in PDF Format
After Printing Some Invoices It Starts giving the following error
Error message" -2147190908 Failed to export the report".
The Number at which the process starts giving this error is not Consistent .
Some time the problem starts after printing 60, 000 Invoice and some times
it starts coming after 40 to 50 thousand.
But once the problem comes , then it keeps coming whatever we do.
We did the following to rectify the problem but of no use
1. Restarted the machine
2. Un installed the Application and re-installed it .
3. Replace the Crystal DLLs , some of them I am listing here (Crxddrt.dll ,
crxdrt.dll, crxDesignerctrl.DLL, CRXDUI.DLL)
4. Applied the HOT fix patch CR85devwin_en.zip on our existing Development
env
It is a very Critical Problem as Implementation is starting from 31st
January , and Client is just waiting for this patch
Any help will be highly appreciated , In case somebody assure me to
solve this problem we can also go for the annual Support Contract.
Please help !!!!
Regards,
RajWe are experiencing the exact same issue. Reports have been exporting fine for over a year and then suddenly we are getting the same export error.
We have also tried reinstalling Crystal and before we re-image the machine, has anyone found a solution to this issue or at least what we can look into.
You said that there is not a set number of reports where you start to see this error. How were you able to get it to start temporarily working again??
Thanks for any help!|||Incase anyone comes looking, our solution was to empty out the temp folder where Crystal was creating the files before converting to PDF. We had over 75000 temp files sitting in the folder. Why Crystal doesn't clean up after itself I don't know, but we ended up creating a service that empties this folder everyday.
Hope this solves your issue as well.
walther|||Bumping this thread for resolution.
Our system just recently experienced the same issue.
Win2k3 Server
Citrix Metaframe XP
Crystal Reports 8.5
Adobe Acrobat 5
I've already uninstall acrobat, crystals, java, and a plethora of other software in hopes of fixing this bug. I've regsvr32 practically all the dlls and deleted the temp files/folders as well.
I've done practically everything short of reinstalling the entire server.
Any suggestions would be greatly appreciated.|||Hello,
I know this is an ancient subject, but I am running into the same issue. I see that Walther, you mentioned that you solved the problem by deleting the files out of the temp folder. Can you tell me where Crystal Reports keeps it's temp files. I want to view that folder on our box to see what it looks like.
Thanks, Neil
Facing an issue while exporting a report(invoice) to PDF in Crystal 8.5 after exporting 1000's of files(invoices) to PDF.
Error msg "2147190908 Failed to export the report". after generating this error, OKB PDF file is generated and we are nt getting any invoices from then.
We have a Licensed Copy of Crystal Reports 8.5 Developer Version
We are facing a Problem while exporting our Invoices in PDF Format
After Printing Some Invoices It Starts giving the following error
Error message" -2147190908 Failed to export the report".
The Number at which the process starts giving this error is not Consistent .
Some time the problem starts after printing 60, 000 Invoice and some times
it starts coming after 40 to 50 thousand.
But once the problem comes , then it keeps coming whatever we do.
We did the following to rectify the problem but of no use
1. Restarted the machine
2. Un installed the Application and re-installed it .
3. Replace the Crystal DLLs , some of them I am listing here (Crxddrt.dll ,
crxdrt.dll, crxDesignerctrl.DLL, CRXDUI.DLL)
4. Applied the HOT fix patch CR85devwin_en.zip on our existing Development
env
It is a very Critical Problem as Implementation is starting from 31st
January , and Client is just waiting for this patch
Any help will be highly appreciated , In case somebody assure me to
solve this problem we can also go for the annual Support Contract.
Please help !!!!
Regards,
RajWe are experiencing the exact same issue. Reports have been exporting fine for over a year and then suddenly we are getting the same export error.
We have also tried reinstalling Crystal and before we re-image the machine, has anyone found a solution to this issue or at least what we can look into.
You said that there is not a set number of reports where you start to see this error. How were you able to get it to start temporarily working again??
Thanks for any help!|||Incase anyone comes looking, our solution was to empty out the temp folder where Crystal was creating the files before converting to PDF. We had over 75000 temp files sitting in the folder. Why Crystal doesn't clean up after itself I don't know, but we ended up creating a service that empties this folder everyday.
Hope this solves your issue as well.
walther|||Bumping this thread for resolution.
Our system just recently experienced the same issue.
Win2k3 Server
Citrix Metaframe XP
Crystal Reports 8.5
Adobe Acrobat 5
I've already uninstall acrobat, crystals, java, and a plethora of other software in hopes of fixing this bug. I've regsvr32 practically all the dlls and deleted the temp files/folders as well.
I've done practically everything short of reinstalling the entire server.
Any suggestions would be greatly appreciated.|||Hello,
I know this is an ancient subject, but I am running into the same issue. I see that Walther, you mentioned that you solved the problem by deleting the files out of the temp folder. Can you tell me where Crystal Reports keeps it's temp files. I want to view that folder on our box to see what it looks like.
Thanks, Neil
20536: Unable to logon server
I have VB 6.0 Application calling Crystal Report 7.0 based on SQL Server 2000 datbase.
I use the LogonServer method with parameter p2ssql.dll to make the database connection.
I have used the above method for my Crystal Report for last 6 years and worked fine until now but now I get the "20536: Unable to logon server " in few XP OS machines.
This again works in the test XP machine I have used, I have almost tried all things I can try to fix the problem.
Does anyone have similar problems and if so how they dealt with it.
Any help in this regard is highly appreciated.
ThanksHigher security levels in XP, at a guess.
Do you have subreports??
If so, you may find that before your OS was allowing subreports to use login info from parent report, but now is breaking because OS demands you supply login info for each subreport.
In which case. iterate thru subreports collection and supply same login info to each subreport.
dave
I use the LogonServer method with parameter p2ssql.dll to make the database connection.
I have used the above method for my Crystal Report for last 6 years and worked fine until now but now I get the "20536: Unable to logon server " in few XP OS machines.
This again works in the test XP machine I have used, I have almost tried all things I can try to fix the problem.
Does anyone have similar problems and if so how they dealt with it.
Any help in this regard is highly appreciated.
ThanksHigher security levels in XP, at a guess.
Do you have subreports??
If so, you may find that before your OS was allowing subreports to use login info from parent report, but now is breaking because OS demands you supply login info for each subreport.
In which case. iterate thru subreports collection and supply same login info to each subreport.
dave
Tuesday, March 6, 2012
2005: Publishing (not exporting) Report in Excel format
My end users want me to post 2 versions of my 2005 Reporting Services
reports. One that when they click on it automatically opens in Excel w/o
grouping...sort of a data dump. Then a second that is grouped, formatted and
pretty.
I know that I can have them export the report once run into Excel, but they
don't want that. (of course...;) So, does anyone know how to publish in
straight Excel in Reporting Services?
thanks in advance for any help!
MachelleYou didn't say if you are using Report Manager or not. The best way is to
use jump to URL and render in CSV ASCII format. The default for CSV is
unicode which Excel opens up with all the data in its own column.
Depending on your report you may or may not want to have a duplicate report
that you have cleaned up and call that one rather than the pretty one.
Regardless, if you have any data size at all URL is much faster.
If you are using Report Manager you could have a report that has no data,
just the parameters and then textboxes, one for pretty, one for Data Export
(I call it that in my link to differentiate that it is a data export, not
the pretty Excel export).
Note, the fields texboxes of the report have a name property that is set
during design to the name of the field. You can give it friendlier names if
you want.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Very nice and very fast.
Bruce Loehle-Conger
"Machelle" <Machelle@.discussions.microsoft.com> wrote in message
news:A5360BDE-440C-4AAF-8D07-46A9D3472567@.microsoft.com...
> My end users want me to post 2 versions of my 2005 Reporting Services
> reports. One that when they click on it automatically opens in Excel w/o
> grouping...sort of a data dump. Then a second that is grouped, formatted
> and
> pretty.
> I know that I can have them export the report once run into Excel, but
> they
> don't want that. (of course...;) So, does anyone know how to publish in
> straight Excel in Reporting Services?
> thanks in advance for any help!
> Machelle
reports. One that when they click on it automatically opens in Excel w/o
grouping...sort of a data dump. Then a second that is grouped, formatted and
pretty.
I know that I can have them export the report once run into Excel, but they
don't want that. (of course...;) So, does anyone know how to publish in
straight Excel in Reporting Services?
thanks in advance for any help!
MachelleYou didn't say if you are using Report Manager or not. The best way is to
use jump to URL and render in CSV ASCII format. The default for CSV is
unicode which Excel opens up with all the data in its own column.
Depending on your report you may or may not want to have a duplicate report
that you have cleaned up and call that one rather than the pretty one.
Regardless, if you have any data size at all URL is much faster.
If you are using Report Manager you could have a report that has no data,
just the parameters and then textboxes, one for pretty, one for Data Export
(I call it that in my link to differentiate that it is a data export, not
the pretty Excel export).
Note, the fields texboxes of the report have a name property that is set
during design to the name of the field. You can give it friendlier names if
you want.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
Very nice and very fast.
Bruce Loehle-Conger
"Machelle" <Machelle@.discussions.microsoft.com> wrote in message
news:A5360BDE-440C-4AAF-8D07-46A9D3472567@.microsoft.com...
> My end users want me to post 2 versions of my 2005 Reporting Services
> reports. One that when they click on it automatically opens in Excel w/o
> grouping...sort of a data dump. Then a second that is grouped, formatted
> and
> pretty.
> I know that I can have them export the report once run into Excel, but
> they
> don't want that. (of course...;) So, does anyone know how to publish in
> straight Excel in Reporting Services?
> thanks in advance for any help!
> Machelle
2005: displaying multi-select parameter values in a text box
I am using Reporting Services 2005. My parameter is a multi-select one. I
want to display what parameters the user chose when they run the report so
others know what data the report was filtered by. When I put the below text
string in a text box, I get an error. When I put the index value after the
string it shows that item if there is one for that index #, and an error if
there isn't. If they chose 5 items for that parameter, I want all 5 to show
up automatically and not have to put the index number for each one to display
it.
=Parameters.pState.value (this gives a query error)
=Parameters.pState.value(3) (this displays the value of the 4th parameter
value they chose. If they didn't choose 4 parameters, then it gives an array
out of bounds error)
If they chose 4 items, I want a piece of code that will automatically show
all 4 (e.g. AZ, NM, NY, FL)
thanks in advance!If you change a report parameter to be multi value, the .Value property will
return an object[] rather than an object. Hence you can no longer e.g. write
expressions like =Parameters!MVP1.Value.ToString().
To access individual values of a multi value parameter you can use
expressions like this:
=Parameters!MVP1.IsMultiValue
boolean flag - tells if a parameter is defined as multi value
=Parameters!MVP1.Count
returns the number of values in the array
=Parameters!MVP1.Value(0)
returns the first selected value
=Join(Parameters!MVP1.Value)
creates a space separated list of values
=Join(Parameters!MVP1.Value, ", ")
creates a comma separated list of values
=Split("a b c", " ")
to create a multi value object array from a string (this can be used
e.g. for drillthrough parameters, subreports, or query parameters)
See also MSDN:
* http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp
* http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp
Hope this helps,
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Machelle" <Machelle@.discussions.microsoft.com> wrote in message
news:2BE1BECC-8CDC-4C0A-9735-0CB291BDD301@.microsoft.com...
>I am using Reporting Services 2005. My parameter is a multi-select one. I
> want to display what parameters the user chose when they run the report so
> others know what data the report was filtered by. When I put the below
> text
> string in a text box, I get an error. When I put the index value after
> the
> string it shows that item if there is one for that index #, and an error
> if
> there isn't. If they chose 5 items for that parameter, I want all 5 to
> show
> up automatically and not have to put the index number for each one to
> display
> it.
> =Parameters.pState.value (this gives a query error)
> =Parameters.pState.value(3) (this displays the value of the 4th parameter
> value they chose. If they didn't choose 4 parameters, then it gives an
> array
> out of bounds error)
> If they chose 4 items, I want a piece of code that will automatically show
> all 4 (e.g. AZ, NM, NY, FL)
> thanks in advance!|||Thank you Robert. You are a God among men! This was SO helpful...
"Robert Bruckner [MSFT]" wrote:
> If you change a report parameter to be multi value, the .Value property will
> return an object[] rather than an object. Hence you can no longer e.g. write
> expressions like =Parameters!MVP1.Value.ToString().
> To access individual values of a multi value parameter you can use
> expressions like this:
> =Parameters!MVP1.IsMultiValue
> boolean flag - tells if a parameter is defined as multi value
> =Parameters!MVP1.Count
> returns the number of values in the array
> =Parameters!MVP1.Value(0)
> returns the first selected value
> =Join(Parameters!MVP1.Value)
> creates a space separated list of values
> =Join(Parameters!MVP1.Value, ", ")
> creates a comma separated list of values
> =Split("a b c", " ")
> to create a multi value object array from a string (this can be used
> e.g. for drillthrough parameters, subreports, or query parameters)
> See also MSDN:
> * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp
> * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp
>
> Hope this helps,
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Machelle" <Machelle@.discussions.microsoft.com> wrote in message
> news:2BE1BECC-8CDC-4C0A-9735-0CB291BDD301@.microsoft.com...
> >I am using Reporting Services 2005. My parameter is a multi-select one. I
> > want to display what parameters the user chose when they run the report so
> > others know what data the report was filtered by. When I put the below
> > text
> > string in a text box, I get an error. When I put the index value after
> > the
> > string it shows that item if there is one for that index #, and an error
> > if
> > there isn't. If they chose 5 items for that parameter, I want all 5 to
> > show
> > up automatically and not have to put the index number for each one to
> > display
> > it.
> >
> > =Parameters.pState.value (this gives a query error)
> > =Parameters.pState.value(3) (this displays the value of the 4th parameter
> > value they chose. If they didn't choose 4 parameters, then it gives an
> > array
> > out of bounds error)
> >
> > If they chose 4 items, I want a piece of code that will automatically show
> > all 4 (e.g. AZ, NM, NY, FL)
> >
> > thanks in advance!
>
>
want to display what parameters the user chose when they run the report so
others know what data the report was filtered by. When I put the below text
string in a text box, I get an error. When I put the index value after the
string it shows that item if there is one for that index #, and an error if
there isn't. If they chose 5 items for that parameter, I want all 5 to show
up automatically and not have to put the index number for each one to display
it.
=Parameters.pState.value (this gives a query error)
=Parameters.pState.value(3) (this displays the value of the 4th parameter
value they chose. If they didn't choose 4 parameters, then it gives an array
out of bounds error)
If they chose 4 items, I want a piece of code that will automatically show
all 4 (e.g. AZ, NM, NY, FL)
thanks in advance!If you change a report parameter to be multi value, the .Value property will
return an object[] rather than an object. Hence you can no longer e.g. write
expressions like =Parameters!MVP1.Value.ToString().
To access individual values of a multi value parameter you can use
expressions like this:
=Parameters!MVP1.IsMultiValue
boolean flag - tells if a parameter is defined as multi value
=Parameters!MVP1.Count
returns the number of values in the array
=Parameters!MVP1.Value(0)
returns the first selected value
=Join(Parameters!MVP1.Value)
creates a space separated list of values
=Join(Parameters!MVP1.Value, ", ")
creates a comma separated list of values
=Split("a b c", " ")
to create a multi value object array from a string (this can be used
e.g. for drillthrough parameters, subreports, or query parameters)
See also MSDN:
* http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp
* http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp
Hope this helps,
--
Robert M. Bruckner
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Machelle" <Machelle@.discussions.microsoft.com> wrote in message
news:2BE1BECC-8CDC-4C0A-9735-0CB291BDD301@.microsoft.com...
>I am using Reporting Services 2005. My parameter is a multi-select one. I
> want to display what parameters the user chose when they run the report so
> others know what data the report was filtered by. When I put the below
> text
> string in a text box, I get an error. When I put the index value after
> the
> string it shows that item if there is one for that index #, and an error
> if
> there isn't. If they chose 5 items for that parameter, I want all 5 to
> show
> up automatically and not have to put the index number for each one to
> display
> it.
> =Parameters.pState.value (this gives a query error)
> =Parameters.pState.value(3) (this displays the value of the 4th parameter
> value they chose. If they didn't choose 4 parameters, then it gives an
> array
> out of bounds error)
> If they chose 4 items, I want a piece of code that will automatically show
> all 4 (e.g. AZ, NM, NY, FL)
> thanks in advance!|||Thank you Robert. You are a God among men! This was SO helpful...
"Robert Bruckner [MSFT]" wrote:
> If you change a report parameter to be multi value, the .Value property will
> return an object[] rather than an object. Hence you can no longer e.g. write
> expressions like =Parameters!MVP1.Value.ToString().
> To access individual values of a multi value parameter you can use
> expressions like this:
> =Parameters!MVP1.IsMultiValue
> boolean flag - tells if a parameter is defined as multi value
> =Parameters!MVP1.Count
> returns the number of values in the array
> =Parameters!MVP1.Value(0)
> returns the first selected value
> =Join(Parameters!MVP1.Value)
> creates a space separated list of values
> =Join(Parameters!MVP1.Value, ", ")
> creates a comma separated list of values
> =Split("a b c", " ")
> to create a multi value object array from a string (this can be used
> e.g. for drillthrough parameters, subreports, or query parameters)
> See also MSDN:
> * http://msdn.microsoft.com/library/en-us/vblr7/html/vafctjoin.asp
> * http://msdn.microsoft.com/library/en-us/vbenlr98/html/vafctsplit.asp
>
> Hope this helps,
> --
> Robert M. Bruckner
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Machelle" <Machelle@.discussions.microsoft.com> wrote in message
> news:2BE1BECC-8CDC-4C0A-9735-0CB291BDD301@.microsoft.com...
> >I am using Reporting Services 2005. My parameter is a multi-select one. I
> > want to display what parameters the user chose when they run the report so
> > others know what data the report was filtered by. When I put the below
> > text
> > string in a text box, I get an error. When I put the index value after
> > the
> > string it shows that item if there is one for that index #, and an error
> > if
> > there isn't. If they chose 5 items for that parameter, I want all 5 to
> > show
> > up automatically and not have to put the index number for each one to
> > display
> > it.
> >
> > =Parameters.pState.value (this gives a query error)
> > =Parameters.pState.value(3) (this displays the value of the 4th parameter
> > value they chose. If they didn't choose 4 parameters, then it gives an
> > array
> > out of bounds error)
> >
> > If they chose 4 items, I want a piece of code that will automatically show
> > all 4 (e.g. AZ, NM, NY, FL)
> >
> > thanks in advance!
>
>
2005 WebService credentials
We have an app that was running against RS 2000 and we call the web
services for (1) rendering a report and (2) creating subscriptions.
I've changed the web references to look at the ReportExecution2005 and
ReportService2005 web services.
Right now the report renders ok, but when I try to create a
subscription, I get:
"...user data source credentials that are required to execute this
report are not stored in the report server database"
We use impersonation and
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
in each case.
We set rs.url to
http://myserver/ReportServer/ReportExecution2005.asmx
for rendering the report
http://myserver/ReportServer/ReportService2005.asmx
for creating the subscription
I've tried changing the user without effect. The impersonated user has
all possible roles granted in Report Manager.
I have not changed any code going from 2000 to 2005.
Any ideas welcome.
TIA,
JimOk, I'm a bit further.
I went into the data source in Report Manager, and by changing the
credentials
I could save a subscription (although I could not retrieve it with the
guid that resulted).
Right now I'm trying to fing the right setup to allow both the report
execution and the saving of subscriptions.|||Were you able to figure this out?
I am having the same problem. Any help would be greatly appreciated.
"jhcorey@.yahoo.com" wrote:
> We have an app that was running against RS 2000 and we call the web
> services for (1) rendering a report and (2) creating subscriptions.
> I've changed the web references to look at the ReportExecution2005 and
> ReportService2005 web services.
> Right now the report renders ok, but when I try to create a
> subscription, I get:
> "...user data source credentials that are required to execute this
> report are not stored in the report server database"
> We use impersonation and
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> in each case.
> We set rs.url to
> http://myserver/ReportServer/ReportExecution2005.asmx
> for rendering the report
> http://myserver/ReportServer/ReportService2005.asmx
> for creating the subscription
> I've tried changing the user without effect. The impersonated user has
> all possible roles granted in Report Manager.
> I have not changed any code going from 2000 to 2005.
> Any ideas welcome.
> TIA,
> Jim
>|||If anyone from Microsoft (or just has the answer to this) is listening...
this is a REAL problem with 2005 reporting services. Storing credentials as
documented does not work and returns an login failure when being used.
These to individuals seemed to be seeing the same problem I'm running into
and no one has offered a suggestion on correction of the issue.
My setup has SQL 2005/RS/IIS on one server so the database is local to RS.
When ever is store the login credentials for the data source, which seems to
be a requred methodology for dynamic subscriptions the result will be a login
failure when attempting to run the report.
"Jessie" wrote:
> Were you able to figure this out?
> I am having the same problem. Any help would be greatly appreciated.
> "jhcorey@.yahoo.com" wrote:
> > We have an app that was running against RS 2000 and we call the web
> > services for (1) rendering a report and (2) creating subscriptions.
> > I've changed the web references to look at the ReportExecution2005 and
> > ReportService2005 web services.
> >
> > Right now the report renders ok, but when I try to create a
> > subscription, I get:
> > "...user data source credentials that are required to execute this
> > report are not stored in the report server database"
> >
> > We use impersonation and
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > in each case.
> >
> > We set rs.url to
> > http://myserver/ReportServer/ReportExecution2005.asmx
> > for rendering the report
> > http://myserver/ReportServer/ReportService2005.asmx
> > for creating the subscription
> >
> > I've tried changing the user without effect. The impersonated user has
> > all possible roles granted in Report Manager.
> >
> > I have not changed any code going from 2000 to 2005.
> >
> > Any ideas welcome.
> >
> > TIA,
> > Jim
> >
> >
services for (1) rendering a report and (2) creating subscriptions.
I've changed the web references to look at the ReportExecution2005 and
ReportService2005 web services.
Right now the report renders ok, but when I try to create a
subscription, I get:
"...user data source credentials that are required to execute this
report are not stored in the report server database"
We use impersonation and
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
in each case.
We set rs.url to
http://myserver/ReportServer/ReportExecution2005.asmx
for rendering the report
http://myserver/ReportServer/ReportService2005.asmx
for creating the subscription
I've tried changing the user without effect. The impersonated user has
all possible roles granted in Report Manager.
I have not changed any code going from 2000 to 2005.
Any ideas welcome.
TIA,
JimOk, I'm a bit further.
I went into the data source in Report Manager, and by changing the
credentials
I could save a subscription (although I could not retrieve it with the
guid that resulted).
Right now I'm trying to fing the right setup to allow both the report
execution and the saving of subscriptions.|||Were you able to figure this out?
I am having the same problem. Any help would be greatly appreciated.
"jhcorey@.yahoo.com" wrote:
> We have an app that was running against RS 2000 and we call the web
> services for (1) rendering a report and (2) creating subscriptions.
> I've changed the web references to look at the ReportExecution2005 and
> ReportService2005 web services.
> Right now the report renders ok, but when I try to create a
> subscription, I get:
> "...user data source credentials that are required to execute this
> report are not stored in the report server database"
> We use impersonation and
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> in each case.
> We set rs.url to
> http://myserver/ReportServer/ReportExecution2005.asmx
> for rendering the report
> http://myserver/ReportServer/ReportService2005.asmx
> for creating the subscription
> I've tried changing the user without effect. The impersonated user has
> all possible roles granted in Report Manager.
> I have not changed any code going from 2000 to 2005.
> Any ideas welcome.
> TIA,
> Jim
>|||If anyone from Microsoft (or just has the answer to this) is listening...
this is a REAL problem with 2005 reporting services. Storing credentials as
documented does not work and returns an login failure when being used.
These to individuals seemed to be seeing the same problem I'm running into
and no one has offered a suggestion on correction of the issue.
My setup has SQL 2005/RS/IIS on one server so the database is local to RS.
When ever is store the login credentials for the data source, which seems to
be a requred methodology for dynamic subscriptions the result will be a login
failure when attempting to run the report.
"Jessie" wrote:
> Were you able to figure this out?
> I am having the same problem. Any help would be greatly appreciated.
> "jhcorey@.yahoo.com" wrote:
> > We have an app that was running against RS 2000 and we call the web
> > services for (1) rendering a report and (2) creating subscriptions.
> > I've changed the web references to look at the ReportExecution2005 and
> > ReportService2005 web services.
> >
> > Right now the report renders ok, but when I try to create a
> > subscription, I get:
> > "...user data source credentials that are required to execute this
> > report are not stored in the report server database"
> >
> > We use impersonation and
> > rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> > in each case.
> >
> > We set rs.url to
> > http://myserver/ReportServer/ReportExecution2005.asmx
> > for rendering the report
> > http://myserver/ReportServer/ReportService2005.asmx
> > for creating the subscription
> >
> > I've tried changing the user without effect. The impersonated user has
> > all possible roles granted in Report Manager.
> >
> > I have not changed any code going from 2000 to 2005.
> >
> > Any ideas welcome.
> >
> > TIA,
> > Jim
> >
> >
2005 URL ris:format=PDF not working
Using the new reporting services I am unable to get the report to go straight
to a pdf...I can select export and it goes fine...below is my url:
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
what am ai doing wrong?Is everything on one machine? Or are you using IE from one machine and RS is
on another?
I was just doing this myself (with CSV instead of PDF) and I found that the
global variable Globals!ReportServerUrl is putting in localhost instead of
the server name (I see below that you have localhost which is why I was
wondering if you are seeing the same issue). If I go to the server and use a
browser from there then my jump to URL works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> Using the new reporting services I am unable to get the report to go
> straight
> to a pdf...I can select export and it goes fine...below is my url:
> http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> what am ai doing wrong?|||yes I am on my development machine with the server and it does not work.
"Bruce L-C [MVP]" wrote:
> Is everything on one machine? Or are you using IE from one machine and RS is
> on another?
> I was just doing this myself (with CSV instead of PDF) and I found that the
> global variable Globals!ReportServerUrl is putting in localhost instead of
> the server name (I see below that you have localhost which is why I was
> wondering if you are seeing the same issue). If I go to the server and use a
> browser from there then my jump to URL works.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> > Using the new reporting services I am unable to get the report to go
> > straight
> > to a pdf...I can select export and it goes fine...below is my url:
> >
> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >
> > what am ai doing wrong?
>
>|||Here is a working URL. The folder is called Demo. The report is called Sales
Order 2 Two parameters StartDate and EndDate
Note that parameters are case sensitive. The %20 is the encoding for space.
Rendering is the default so you can leave it off the line.
Try to match my pattern here and hopefully it will work for you. The user
will still have to click open, it will not automatically open
http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> yes I am on my development machine with the server and it does not work.
>
> "Bruce L-C [MVP]" wrote:
>> Is everything on one machine? Or are you using IE from one machine and RS
>> is
>> on another?
>> I was just doing this myself (with CSV instead of PDF) and I found that
>> the
>> global variable Globals!ReportServerUrl is putting in localhost instead
>> of
>> the server name (I see below that you have localhost which is why I was
>> wondering if you are seeing the same issue). If I go to the server and
>> use a
>> browser from there then my jump to URL works.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> > Using the new reporting services I am unable to get the report to go
>> > straight
>> > to a pdf...I can select export and it goes fine...below is my url:
>> >
>> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >
>> > what am ai doing wrong?
>>|||Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
What I am looking for is to simulate the report server actions of selecting
the PDF format and clicking the export link,
opens another window and its converted to the PDF format but already open to
the PDF viewer.
Then if the user wants to save it from there they can, butthe ofrmatting
seems more stable this way.
Is this not possible with the url?
"Bruce L-C [MVP]" wrote:
> Here is a working URL. The folder is called Demo. The report is called Sales
> Order 2 Two parameters StartDate and EndDate
> Note that parameters are case sensitive. The %20 is the encoding for space.
> Rendering is the default so you can leave it off the line.
> Try to match my pattern here and hopefully it will work for you. The user
> will still have to click open, it will not automatically open
> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> > yes I am on my development machine with the server and it does not work.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Is everything on one machine? Or are you using IE from one machine and RS
> >> is
> >> on another?
> >>
> >> I was just doing this myself (with CSV instead of PDF) and I found that
> >> the
> >> global variable Globals!ReportServerUrl is putting in localhost instead
> >> of
> >> the server name (I see below that you have localhost which is why I was
> >> wondering if you are seeing the same issue). If I go to the server and
> >> use a
> >> browser from there then my jump to URL works.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> > Using the new reporting services I am unable to get the report to go
> >> > straight
> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >
> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >
> >> > what am ai doing wrong?
> >>
> >>
> >>
>
>|||Export is working differently in RS 2005. Previously it gave you the
open/save dialog. Now it is opening it up in the browser. It seems like if
the export functionality can open it up in the browser then we should be
able to do it with the URL. I tried several things and cannot get it to
happen. I will use my MS contacts to see if there is a way to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> What I am looking for is to simulate the report server actions of
> selecting
> the PDF format and clicking the export link,
> opens another window and its converted to the PDF format but already open
> to
> the PDF viewer.
> Then if the user wants to save it from there they can, butthe ofrmatting
> seems more stable this way.
> Is this not possible with the url?
> "Bruce L-C [MVP]" wrote:
>> Here is a working URL. The folder is called Demo. The report is called
>> Sales
>> Order 2 Two parameters StartDate and EndDate
>> Note that parameters are case sensitive. The %20 is the encoding for
>> space.
>> Rendering is the default so you can leave it off the line.
>> Try to match my pattern here and hopefully it will work for you. The user
>> will still have to click open, it will not automatically open
>> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> > yes I am on my development machine with the server and it does not
>> > work.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Is everything on one machine? Or are you using IE from one machine and
>> >> RS
>> >> is
>> >> on another?
>> >>
>> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> that
>> >> the
>> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> instead
>> >> of
>> >> the server name (I see below that you have localhost which is why I
>> >> was
>> >> wondering if you are seeing the same issue). If I go to the server and
>> >> use a
>> >> browser from there then my jump to URL works.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> > Using the new reporting services I am unable to get the report to go
>> >> > straight
>> >> > to a pdf...I can select export and it goes fine...below is my url:
>> >> >
>> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >
>> >> > what am ai doing wrong?
>> >>
>> >>
>> >>
>>|||That would be Great!
THANKS!
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||any luck on this...?
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I've sent an email. No response yet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> any luck on this...?
> "Bruce L-C [MVP]" wrote:
>> Export is working differently in RS 2005. Previously it gave you the
>> open/save dialog. Now it is opening it up in the browser. It seems like
>> if
>> the export functionality can open it up in the browser then we should be
>> able to do it with the URL. I tried several things and cannot get it to
>> happen. I will use my MS contacts to see if there is a way to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
>> > Thanks, that works to get me a SAVEAS dialog with the pdf file
>> > perfectly!
>> >
>> > What I am looking for is to simulate the report server actions of
>> > selecting
>> > the PDF format and clicking the export link,
>> > opens another window and its converted to the PDF format but already
>> > open
>> > to
>> > the PDF viewer.
>> >
>> > Then if the user wants to save it from there they can, butthe
>> > ofrmatting
>> > seems more stable this way.
>> >
>> > Is this not possible with the url?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Here is a working URL. The folder is called Demo. The report is called
>> >> Sales
>> >> Order 2 Two parameters StartDate and EndDate
>> >>
>> >> Note that parameters are case sensitive. The %20 is the encoding for
>> >> space.
>> >> Rendering is the default so you can leave it off the line.
>> >>
>> >> Try to match my pattern here and hopefully it will work for you. The
>> >> user
>> >> will still have to click open, it will not automatically open
>> >>
>> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> >> > yes I am on my development machine with the server and it does not
>> >> > work.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Is everything on one machine? Or are you using IE from one machine
>> >> >> and
>> >> >> RS
>> >> >> is
>> >> >> on another?
>> >> >>
>> >> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> >> that
>> >> >> the
>> >> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> >> instead
>> >> >> of
>> >> >> the server name (I see below that you have localhost which is why I
>> >> >> was
>> >> >> wondering if you are seeing the same issue). If I go to the server
>> >> >> and
>> >> >> use a
>> >> >> browser from there then my jump to URL works.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> >> > Using the new reporting services I am unable to get the report to
>> >> >> > go
>> >> >> > straight
>> >> >> > to a pdf...I can select export and it goes fine...below is my
>> >> >> > url:
>> >> >> >
>> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >> >
>> >> >> > what am ai doing wrong?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks!
"Bruce L-C [MVP]" wrote:
> I've sent an email. No response yet.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> > any luck on this...?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Export is working differently in RS 2005. Previously it gave you the
> >> open/save dialog. Now it is opening it up in the browser. It seems like
> >> if
> >> the export functionality can open it up in the browser then we should be
> >> able to do it with the URL. I tried several things and cannot get it to
> >> happen. I will use my MS contacts to see if there is a way to do this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> >> > Thanks, that works to get me a SAVEAS dialog with the pdf file
> >> > perfectly!
> >> >
> >> > What I am looking for is to simulate the report server actions of
> >> > selecting
> >> > the PDF format and clicking the export link,
> >> > opens another window and its converted to the PDF format but already
> >> > open
> >> > to
> >> > the PDF viewer.
> >> >
> >> > Then if the user wants to save it from there they can, butthe
> >> > ofrmatting
> >> > seems more stable this way.
> >> >
> >> > Is this not possible with the url?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Here is a working URL. The folder is called Demo. The report is called
> >> >> Sales
> >> >> Order 2 Two parameters StartDate and EndDate
> >> >>
> >> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> >> space.
> >> >> Rendering is the default so you can leave it off the line.
> >> >>
> >> >> Try to match my pattern here and hopefully it will work for you. The
> >> >> user
> >> >> will still have to click open, it will not automatically open
> >> >>
> >> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> >> > yes I am on my development machine with the server and it does not
> >> >> > work.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Is everything on one machine? Or are you using IE from one machine
> >> >> >> and
> >> >> >> RS
> >> >> >> is
> >> >> >> on another?
> >> >> >>
> >> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> >> that
> >> >> >> the
> >> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> >> instead
> >> >> >> of
> >> >> >> the server name (I see below that you have localhost which is why I
> >> >> >> was
> >> >> >> wondering if you are seeing the same issue). If I go to the server
> >> >> >> and
> >> >> >> use a
> >> >> >> browser from there then my jump to URL works.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> >> > Using the new reporting services I am unable to get the report to
> >> >> >> > go
> >> >> >> > straight
> >> >> >> > to a pdf...I can select export and it goes fine...below is my
> >> >> >> > url:
> >> >> >> >
> >> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >> >
> >> >> >> > what am ai doing wrong?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
to a pdf...I can select export and it goes fine...below is my url:
http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
what am ai doing wrong?Is everything on one machine? Or are you using IE from one machine and RS is
on another?
I was just doing this myself (with CSV instead of PDF) and I found that the
global variable Globals!ReportServerUrl is putting in localhost instead of
the server name (I see below that you have localhost which is why I was
wondering if you are seeing the same issue). If I go to the server and use a
browser from there then my jump to URL works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> Using the new reporting services I am unable to get the report to go
> straight
> to a pdf...I can select export and it goes fine...below is my url:
> http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> what am ai doing wrong?|||yes I am on my development machine with the server and it does not work.
"Bruce L-C [MVP]" wrote:
> Is everything on one machine? Or are you using IE from one machine and RS is
> on another?
> I was just doing this myself (with CSV instead of PDF) and I found that the
> global variable Globals!ReportServerUrl is putting in localhost instead of
> the server name (I see below that you have localhost which is why I was
> wondering if you are seeing the same issue). If I go to the server and use a
> browser from there then my jump to URL works.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> > Using the new reporting services I am unable to get the report to go
> > straight
> > to a pdf...I can select export and it goes fine...below is my url:
> >
> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >
> > what am ai doing wrong?
>
>|||Here is a working URL. The folder is called Demo. The report is called Sales
Order 2 Two parameters StartDate and EndDate
Note that parameters are case sensitive. The %20 is the encoding for space.
Rendering is the default so you can leave it off the line.
Try to match my pattern here and hopefully it will work for you. The user
will still have to click open, it will not automatically open
http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> yes I am on my development machine with the server and it does not work.
>
> "Bruce L-C [MVP]" wrote:
>> Is everything on one machine? Or are you using IE from one machine and RS
>> is
>> on another?
>> I was just doing this myself (with CSV instead of PDF) and I found that
>> the
>> global variable Globals!ReportServerUrl is putting in localhost instead
>> of
>> the server name (I see below that you have localhost which is why I was
>> wondering if you are seeing the same issue). If I go to the server and
>> use a
>> browser from there then my jump to URL works.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> > Using the new reporting services I am unable to get the report to go
>> > straight
>> > to a pdf...I can select export and it goes fine...below is my url:
>> >
>> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >
>> > what am ai doing wrong?
>>|||Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
What I am looking for is to simulate the report server actions of selecting
the PDF format and clicking the export link,
opens another window and its converted to the PDF format but already open to
the PDF viewer.
Then if the user wants to save it from there they can, butthe ofrmatting
seems more stable this way.
Is this not possible with the url?
"Bruce L-C [MVP]" wrote:
> Here is a working URL. The folder is called Demo. The report is called Sales
> Order 2 Two parameters StartDate and EndDate
> Note that parameters are case sensitive. The %20 is the encoding for space.
> Rendering is the default so you can leave it off the line.
> Try to match my pattern here and hopefully it will work for you. The user
> will still have to click open, it will not automatically open
> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> > yes I am on my development machine with the server and it does not work.
> >
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Is everything on one machine? Or are you using IE from one machine and RS
> >> is
> >> on another?
> >>
> >> I was just doing this myself (with CSV instead of PDF) and I found that
> >> the
> >> global variable Globals!ReportServerUrl is putting in localhost instead
> >> of
> >> the server name (I see below that you have localhost which is why I was
> >> wondering if you are seeing the same issue). If I go to the server and
> >> use a
> >> browser from there then my jump to URL works.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> > Using the new reporting services I am unable to get the report to go
> >> > straight
> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >
> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >
> >> > what am ai doing wrong?
> >>
> >>
> >>
>
>|||Export is working differently in RS 2005. Previously it gave you the
open/save dialog. Now it is opening it up in the browser. It seems like if
the export functionality can open it up in the browser then we should be
able to do it with the URL. I tried several things and cannot get it to
happen. I will use my MS contacts to see if there is a way to do this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> What I am looking for is to simulate the report server actions of
> selecting
> the PDF format and clicking the export link,
> opens another window and its converted to the PDF format but already open
> to
> the PDF viewer.
> Then if the user wants to save it from there they can, butthe ofrmatting
> seems more stable this way.
> Is this not possible with the url?
> "Bruce L-C [MVP]" wrote:
>> Here is a working URL. The folder is called Demo. The report is called
>> Sales
>> Order 2 Two parameters StartDate and EndDate
>> Note that parameters are case sensitive. The %20 is the encoding for
>> space.
>> Rendering is the default so you can leave it off the line.
>> Try to match my pattern here and hopefully it will work for you. The user
>> will still have to click open, it will not automatically open
>> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> > yes I am on my development machine with the server and it does not
>> > work.
>> >
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Is everything on one machine? Or are you using IE from one machine and
>> >> RS
>> >> is
>> >> on another?
>> >>
>> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> that
>> >> the
>> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> instead
>> >> of
>> >> the server name (I see below that you have localhost which is why I
>> >> was
>> >> wondering if you are seeing the same issue). If I go to the server and
>> >> use a
>> >> browser from there then my jump to URL works.
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> > Using the new reporting services I am unable to get the report to go
>> >> > straight
>> >> > to a pdf...I can select export and it goes fine...below is my url:
>> >> >
>> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >
>> >> > what am ai doing wrong?
>> >>
>> >>
>> >>
>>|||That would be Great!
THANKS!
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||any luck on this...?
"Bruce L-C [MVP]" wrote:
> Export is working differently in RS 2005. Previously it gave you the
> open/save dialog. Now it is opening it up in the browser. It seems like if
> the export functionality can open it up in the browser then we should be
> able to do it with the URL. I tried several things and cannot get it to
> happen. I will use my MS contacts to see if there is a way to do this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> > Thanks, that works to get me a SAVEAS dialog with the pdf file perfectly!
> >
> > What I am looking for is to simulate the report server actions of
> > selecting
> > the PDF format and clicking the export link,
> > opens another window and its converted to the PDF format but already open
> > to
> > the PDF viewer.
> >
> > Then if the user wants to save it from there they can, butthe ofrmatting
> > seems more stable this way.
> >
> > Is this not possible with the url?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Here is a working URL. The folder is called Demo. The report is called
> >> Sales
> >> Order 2 Two parameters StartDate and EndDate
> >>
> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> space.
> >> Rendering is the default so you can leave it off the line.
> >>
> >> Try to match my pattern here and hopefully it will work for you. The user
> >> will still have to click open, it will not automatically open
> >>
> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> > yes I am on my development machine with the server and it does not
> >> > work.
> >> >
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Is everything on one machine? Or are you using IE from one machine and
> >> >> RS
> >> >> is
> >> >> on another?
> >> >>
> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> that
> >> >> the
> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> instead
> >> >> of
> >> >> the server name (I see below that you have localhost which is why I
> >> >> was
> >> >> wondering if you are seeing the same issue). If I go to the server and
> >> >> use a
> >> >> browser from there then my jump to URL works.
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> > Using the new reporting services I am unable to get the report to go
> >> >> > straight
> >> >> > to a pdf...I can select export and it goes fine...below is my url:
> >> >> >
> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >
> >> >> > what am ai doing wrong?
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I've sent an email. No response yet.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> any luck on this...?
> "Bruce L-C [MVP]" wrote:
>> Export is working differently in RS 2005. Previously it gave you the
>> open/save dialog. Now it is opening it up in the browser. It seems like
>> if
>> the export functionality can open it up in the browser then we should be
>> able to do it with the URL. I tried several things and cannot get it to
>> happen. I will use my MS contacts to see if there is a way to do this.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
>> > Thanks, that works to get me a SAVEAS dialog with the pdf file
>> > perfectly!
>> >
>> > What I am looking for is to simulate the report server actions of
>> > selecting
>> > the PDF format and clicking the export link,
>> > opens another window and its converted to the PDF format but already
>> > open
>> > to
>> > the PDF viewer.
>> >
>> > Then if the user wants to save it from there they can, butthe
>> > ofrmatting
>> > seems more stable this way.
>> >
>> > Is this not possible with the url?
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Here is a working URL. The folder is called Demo. The report is called
>> >> Sales
>> >> Order 2 Two parameters StartDate and EndDate
>> >>
>> >> Note that parameters are case sensitive. The %20 is the encoding for
>> >> space.
>> >> Rendering is the default so you can leave it off the line.
>> >>
>> >> Try to match my pattern here and hopefully it will work for you. The
>> >> user
>> >> will still have to click open, it will not automatically open
>> >>
>> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
>> >>
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
>> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
>> >> > yes I am on my development machine with the server and it does not
>> >> > work.
>> >> >
>> >> >
>> >> > "Bruce L-C [MVP]" wrote:
>> >> >
>> >> >> Is everything on one machine? Or are you using IE from one machine
>> >> >> and
>> >> >> RS
>> >> >> is
>> >> >> on another?
>> >> >>
>> >> >> I was just doing this myself (with CSV instead of PDF) and I found
>> >> >> that
>> >> >> the
>> >> >> global variable Globals!ReportServerUrl is putting in localhost
>> >> >> instead
>> >> >> of
>> >> >> the server name (I see below that you have localhost which is why I
>> >> >> was
>> >> >> wondering if you are seeing the same issue). If I go to the server
>> >> >> and
>> >> >> use a
>> >> >> browser from there then my jump to URL works.
>> >> >>
>> >> >>
>> >> >> --
>> >> >> Bruce Loehle-Conger
>> >> >> MVP SQL Server Reporting Services
>> >> >>
>> >> >>
>> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
>> >> >> > Using the new reporting services I am unable to get the report to
>> >> >> > go
>> >> >> > straight
>> >> >> > to a pdf...I can select export and it goes fine...below is my
>> >> >> > url:
>> >> >> >
>> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
>> >> >> >
>> >> >> > what am ai doing wrong?
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>|||Thanks!
"Bruce L-C [MVP]" wrote:
> I've sent an email. No response yet.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> news:DB300404-B8A2-48CD-999F-4A5C453C0984@.microsoft.com...
> > any luck on this...?
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Export is working differently in RS 2005. Previously it gave you the
> >> open/save dialog. Now it is opening it up in the browser. It seems like
> >> if
> >> the export functionality can open it up in the browser then we should be
> >> able to do it with the URL. I tried several things and cannot get it to
> >> happen. I will use my MS contacts to see if there is a way to do this.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> news:BAD1D5E0-A54E-47E4-A3D8-06B2AE0F7E7D@.microsoft.com...
> >> > Thanks, that works to get me a SAVEAS dialog with the pdf file
> >> > perfectly!
> >> >
> >> > What I am looking for is to simulate the report server actions of
> >> > selecting
> >> > the PDF format and clicking the export link,
> >> > opens another window and its converted to the PDF format but already
> >> > open
> >> > to
> >> > the PDF viewer.
> >> >
> >> > Then if the user wants to save it from there they can, butthe
> >> > ofrmatting
> >> > seems more stable this way.
> >> >
> >> > Is this not possible with the url?
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Here is a working URL. The folder is called Demo. The report is called
> >> >> Sales
> >> >> Order 2 Two parameters StartDate and EndDate
> >> >>
> >> >> Note that parameters are case sensitive. The %20 is the encoding for
> >> >> space.
> >> >> Rendering is the default so you can leave it off the line.
> >> >>
> >> >> Try to match my pattern here and hopefully it will work for you. The
> >> >> user
> >> >> will still have to click open, it will not automatically open
> >> >>
> >> >> http://localhost/ReportServer?/Demo/Sales%20Order%20Detail%202&StartDate=9/1/2003&EndDate=9/2/2003&rs:Format=PDF
> >> >>
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in message
> >> >> news:6CA9A8E7-551D-44D3-858E-A606BFCC06B8@.microsoft.com...
> >> >> > yes I am on my development machine with the server and it does not
> >> >> > work.
> >> >> >
> >> >> >
> >> >> > "Bruce L-C [MVP]" wrote:
> >> >> >
> >> >> >> Is everything on one machine? Or are you using IE from one machine
> >> >> >> and
> >> >> >> RS
> >> >> >> is
> >> >> >> on another?
> >> >> >>
> >> >> >> I was just doing this myself (with CSV instead of PDF) and I found
> >> >> >> that
> >> >> >> the
> >> >> >> global variable Globals!ReportServerUrl is putting in localhost
> >> >> >> instead
> >> >> >> of
> >> >> >> the server name (I see below that you have localhost which is why I
> >> >> >> was
> >> >> >> wondering if you are seeing the same issue). If I go to the server
> >> >> >> and
> >> >> >> use a
> >> >> >> browser from there then my jump to URL works.
> >> >> >>
> >> >> >>
> >> >> >> --
> >> >> >> Bruce Loehle-Conger
> >> >> >> MVP SQL Server Reporting Services
> >> >> >>
> >> >> >>
> >> >> >> "Bilderbach" <Bilderbach@.discussions.microsoft.com> wrote in
> >> >> >> message
> >> >> >> news:F8E182F9-4160-44B7-88DA-F7302C9789AE@.microsoft.com...
> >> >> >> > Using the new reporting services I am unable to get the report to
> >> >> >> > go
> >> >> >> > straight
> >> >> >> > to a pdf...I can select export and it goes fine...below is my
> >> >> >> > url:
> >> >> >> >
> >> >> >> > http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fPassParemetersOnUrl%2fPassUrlTest&rs%3ACommand=Render&rs%3Aformat=PDF&lastname=jones
> >> >> >> >
> >> >> >> > what am ai doing wrong?
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
Friday, February 24, 2012
2005 Reporting Srv cannot connect to Oracle datasource on web server
created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)
any thoughts or direction greatly appreciated
Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
-- Robert
|||Robert,
Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?
thanks again,
Richard
|||Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.
Dave
2005 Reporting Srv cannot connect to Oracle datasource on web server
created an Oracle datasource (tried both ole db & oracle client) in Visual Studio 2005 report project - works fine connecting and preview of report within ide , deployed to Reporting Services web server, received the following error when attempting to run the report on web server:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'oracle'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
web server has oracle client 9i client installed and connecting to db ok through sql plus (this server also is loaded with VS2005 and the SqlServer2005 db)
any thoughts or direction greatly appreciated
Most likely the RS web service and the RS windows service cannot access the Oracle client installation due to missing file system permissions. Please read the following KB article: http://support.microsoft.com/default.aspx?scid=kb;en-us;870668
-- Robert
|||Robert,
Thanks for the help, this did in fact solve the issue (once the permissions were granted for the entire Oracle directory). Why would such a helpful article not show up in my searches through the help maze? Is there another entry point to search for these articles other than the help search engine?
thanks again,
Richard
|||Wow this really helped me out also, had the exact same problem. Thanks. I too had to set the permissions for the entire Oracle directory for this to work. Also take note of which account your installation is using, mine wasn't using the Network Service account but instead a special service account created by the system admins, I had to set the permissions for that account on the folders.
Dave
2005 reporting services and parameters
I have created an SP that has 3 parameters.
I would like to creat a report using this SP. in other reporting tools I
have created the report and I had it call an SP instead of using a query.
the reporting tools would alway add the paramters to the report and ask for
the info.
I can't seem to create a report using SQL reporting services. I add
"exec ProcNAme" in the report wizard, but it tells me it is expecting
paramaters. I can't hard code the paramters, that would defeat the purpose
of params.
TIA,
JoeSupport for sp in the wizards is weak. Hard code the parameter just for the
wizard.
exec yourproc 'sometext', 0.101,'someothertext'
After running the wizard go to the dataset, change the command type to
stored procedure and put in just the name of the stored procedure (do not
put exec).
yourproc
RS will now recognize the parameters and add report parameters to match the
query parameters and map them. It is important to understand that query
params and report parameters are two different things. The reason it is
important is because you can base a query parameter on a expression instead
of using a report parameter.
Anyway, that is an aside. Follow the above and it should work for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:0E52E72C-190A-4052-BA09-4527EB8831B3@.microsoft.com...
>I have created an SP that has 3 parameters.
> I would like to creat a report using this SP. in other reporting tools I
> have created the report and I had it call an SP instead of using a query.
> the reporting tools would alway add the paramters to the report and ask
> for
> the info.
> I can't seem to create a report using SQL reporting services. I add
> "exec ProcNAme" in the report wizard, but it tells me it is expecting
> paramaters. I can't hard code the paramters, that would defeat the
> purpose
> of params.
> TIA,
> Joe|||Thank you! This was driving me crazy.
"Bruce L-C [MVP]" wrote:
> Support for sp in the wizards is weak. Hard code the parameter just for the
> wizard.
> exec yourproc 'sometext', 0.101,'someothertext'
> After running the wizard go to the dataset, change the command type to
> stored procedure and put in just the name of the stored procedure (do not
> put exec).
> yourproc
> RS will now recognize the parameters and add report parameters to match the
> query parameters and map them. It is important to understand that query
> params and report parameters are two different things. The reason it is
> important is because you can base a query parameter on a expression instead
> of using a report parameter.
> Anyway, that is an aside. Follow the above and it should work for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:0E52E72C-190A-4052-BA09-4527EB8831B3@.microsoft.com...
> >I have created an SP that has 3 parameters.
> > I would like to creat a report using this SP. in other reporting tools I
> > have created the report and I had it call an SP instead of using a query.
> > the reporting tools would alway add the paramters to the report and ask
> > for
> > the info.
> > I can't seem to create a report using SQL reporting services. I add
> > "exec ProcNAme" in the report wizard, but it tells me it is expecting
> > paramaters. I can't hard code the paramters, that would defeat the
> > purpose
> > of params.
> > TIA,
> > Joe
>
>|||Have you also noticed that SQL 2005 reporting services does not like #temp
tables?
I dont understand what Microsoft was thinking, I use temp tables in just
about every Stored Proc I write.
Thanks,
Joe|||Not true.
I use temp tables all the time.
Do the following. Do not explicitly drop the table in your stored procedure.
I.e. do not do this:
drop table #temp
Let it fall out of scope naturally.
Second, do a select statement before exiting your stored procedure.
Something like this:
select * from #temp
Just about every stored procedure I use uses temp tables without any problem
whatsoever.
If you continue to have problems post some examples of what you are doing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:EF45BAF3-F049-4FF5-B144-30F294B3AE2B@.microsoft.com...
> Have you also noticed that SQL 2005 reporting services does not like #temp
> tables?
> I dont understand what Microsoft was thinking, I use temp tables in just
> about every Stored Proc I write.
> Thanks,
> Joe|||Thank you. I will try this on my next proc. Most of my temp tables are
created using select into statements. This could be my issue.
Thanks again for the help.
Joe
"Bruce L-C [MVP]" wrote:
> Not true.
> I use temp tables all the time.
> Do the following. Do not explicitly drop the table in your stored procedure.
> I.e. do not do this:
> drop table #temp
> Let it fall out of scope naturally.
> Second, do a select statement before exiting your stored procedure.
> Something like this:
> select * from #temp
> Just about every stored procedure I use uses temp tables without any problem
> whatsoever.
> If you continue to have problems post some examples of what you are doing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:EF45BAF3-F049-4FF5-B144-30F294B3AE2B@.microsoft.com...
> > Have you also noticed that SQL 2005 reporting services does not like #temp
> > tables?
> >
> > I dont understand what Microsoft was thinking, I use temp tables in just
> > about every Stored Proc I write.
> >
> > Thanks,
> > Joe
>
>|||Select into is fine. But, you also need to finish up with a Select * from
#temp.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:9743C586-BF52-4FAB-ABF0-84A09F22958D@.microsoft.com...
> Thank you. I will try this on my next proc. Most of my temp tables are
> created using select into statements. This could be my issue.
> Thanks again for the help.
> Joe
>
> "Bruce L-C [MVP]" wrote:
>> Not true.
>> I use temp tables all the time.
>> Do the following. Do not explicitly drop the table in your stored
>> procedure.
>> I.e. do not do this:
>> drop table #temp
>> Let it fall out of scope naturally.
>> Second, do a select statement before exiting your stored procedure.
>> Something like this:
>> select * from #temp
>> Just about every stored procedure I use uses temp tables without any
>> problem
>> whatsoever.
>> If you continue to have problems post some examples of what you are
>> doing.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
>> news:EF45BAF3-F049-4FF5-B144-30F294B3AE2B@.microsoft.com...
>> > Have you also noticed that SQL 2005 reporting services does not like
>> > #temp
>> > tables?
>> >
>> > I dont understand what Microsoft was thinking, I use temp tables in
>> > just
>> > about every Stored Proc I write.
>> >
>> > Thanks,
>> > Joe
>>
I would like to creat a report using this SP. in other reporting tools I
have created the report and I had it call an SP instead of using a query.
the reporting tools would alway add the paramters to the report and ask for
the info.
I can't seem to create a report using SQL reporting services. I add
"exec ProcNAme" in the report wizard, but it tells me it is expecting
paramaters. I can't hard code the paramters, that would defeat the purpose
of params.
TIA,
JoeSupport for sp in the wizards is weak. Hard code the parameter just for the
wizard.
exec yourproc 'sometext', 0.101,'someothertext'
After running the wizard go to the dataset, change the command type to
stored procedure and put in just the name of the stored procedure (do not
put exec).
yourproc
RS will now recognize the parameters and add report parameters to match the
query parameters and map them. It is important to understand that query
params and report parameters are two different things. The reason it is
important is because you can base a query parameter on a expression instead
of using a report parameter.
Anyway, that is an aside. Follow the above and it should work for you.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:0E52E72C-190A-4052-BA09-4527EB8831B3@.microsoft.com...
>I have created an SP that has 3 parameters.
> I would like to creat a report using this SP. in other reporting tools I
> have created the report and I had it call an SP instead of using a query.
> the reporting tools would alway add the paramters to the report and ask
> for
> the info.
> I can't seem to create a report using SQL reporting services. I add
> "exec ProcNAme" in the report wizard, but it tells me it is expecting
> paramaters. I can't hard code the paramters, that would defeat the
> purpose
> of params.
> TIA,
> Joe|||Thank you! This was driving me crazy.
"Bruce L-C [MVP]" wrote:
> Support for sp in the wizards is weak. Hard code the parameter just for the
> wizard.
> exec yourproc 'sometext', 0.101,'someothertext'
> After running the wizard go to the dataset, change the command type to
> stored procedure and put in just the name of the stored procedure (do not
> put exec).
> yourproc
> RS will now recognize the parameters and add report parameters to match the
> query parameters and map them. It is important to understand that query
> params and report parameters are two different things. The reason it is
> important is because you can base a query parameter on a expression instead
> of using a report parameter.
> Anyway, that is an aside. Follow the above and it should work for you.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:0E52E72C-190A-4052-BA09-4527EB8831B3@.microsoft.com...
> >I have created an SP that has 3 parameters.
> > I would like to creat a report using this SP. in other reporting tools I
> > have created the report and I had it call an SP instead of using a query.
> > the reporting tools would alway add the paramters to the report and ask
> > for
> > the info.
> > I can't seem to create a report using SQL reporting services. I add
> > "exec ProcNAme" in the report wizard, but it tells me it is expecting
> > paramaters. I can't hard code the paramters, that would defeat the
> > purpose
> > of params.
> > TIA,
> > Joe
>
>|||Have you also noticed that SQL 2005 reporting services does not like #temp
tables?
I dont understand what Microsoft was thinking, I use temp tables in just
about every Stored Proc I write.
Thanks,
Joe|||Not true.
I use temp tables all the time.
Do the following. Do not explicitly drop the table in your stored procedure.
I.e. do not do this:
drop table #temp
Let it fall out of scope naturally.
Second, do a select statement before exiting your stored procedure.
Something like this:
select * from #temp
Just about every stored procedure I use uses temp tables without any problem
whatsoever.
If you continue to have problems post some examples of what you are doing.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:EF45BAF3-F049-4FF5-B144-30F294B3AE2B@.microsoft.com...
> Have you also noticed that SQL 2005 reporting services does not like #temp
> tables?
> I dont understand what Microsoft was thinking, I use temp tables in just
> about every Stored Proc I write.
> Thanks,
> Joe|||Thank you. I will try this on my next proc. Most of my temp tables are
created using select into statements. This could be my issue.
Thanks again for the help.
Joe
"Bruce L-C [MVP]" wrote:
> Not true.
> I use temp tables all the time.
> Do the following. Do not explicitly drop the table in your stored procedure.
> I.e. do not do this:
> drop table #temp
> Let it fall out of scope naturally.
> Second, do a select statement before exiting your stored procedure.
> Something like this:
> select * from #temp
> Just about every stored procedure I use uses temp tables without any problem
> whatsoever.
> If you continue to have problems post some examples of what you are doing.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
> news:EF45BAF3-F049-4FF5-B144-30F294B3AE2B@.microsoft.com...
> > Have you also noticed that SQL 2005 reporting services does not like #temp
> > tables?
> >
> > I dont understand what Microsoft was thinking, I use temp tables in just
> > about every Stored Proc I write.
> >
> > Thanks,
> > Joe
>
>|||Select into is fine. But, you also need to finish up with a Select * from
#temp.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:9743C586-BF52-4FAB-ABF0-84A09F22958D@.microsoft.com...
> Thank you. I will try this on my next proc. Most of my temp tables are
> created using select into statements. This could be my issue.
> Thanks again for the help.
> Joe
>
> "Bruce L-C [MVP]" wrote:
>> Not true.
>> I use temp tables all the time.
>> Do the following. Do not explicitly drop the table in your stored
>> procedure.
>> I.e. do not do this:
>> drop table #temp
>> Let it fall out of scope naturally.
>> Second, do a select statement before exiting your stored procedure.
>> Something like this:
>> select * from #temp
>> Just about every stored procedure I use uses temp tables without any
>> problem
>> whatsoever.
>> If you continue to have problems post some examples of what you are
>> doing.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "jaylou" <jaylou@.discussions.microsoft.com> wrote in message
>> news:EF45BAF3-F049-4FF5-B144-30F294B3AE2B@.microsoft.com...
>> > Have you also noticed that SQL 2005 reporting services does not like
>> > #temp
>> > tables?
>> >
>> > I dont understand what Microsoft was thinking, I use temp tables in
>> > just
>> > about every Stored Proc I write.
>> >
>> > Thanks,
>> > Joe
>>
2005 Reporting service - change commandtext runtime from .net
Hi
I am new to SSRS and have some trouble.
I have a report which is deployed and I can show this report
in a project ( asp.net Framework vs. 2 ) using
Microsoft.Reporting.WebForms.ReportViewer.
Thats fine, but now I have to make up some code for changing the
Query used in my datasets:
I need to get my sql, and modify it ( put on some "Where... ", "exists()",
and so on ) - then put the sql back in the report and then execute/show the
report.
I am familiar with parameters, but parameters can't cover my needs.
I've googled and found a lot of stuff, but I can't find any examples - maybe
it is because I don't know which words to use, or how to filter the
information
Hope somebody can help
Thanks
ChristinaI don't believe you can do that when the ReportViewer is in "Remote" mode
but in "Local" mode you are the one that supplies the DataSource to report
so you can execute whatever queries you want and then pass the DataSource
into the report by doing ReportViewer.LocalReport.DataSources.Add.
You can find a lot of good examples and information for ReportViewer here:
http://www.gotreportviewer.com/
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Chrisser" <cbj@.egdatainform.dk>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: 2005 Reporting service - change commandtext runtime from .net
> Date: Thu, 4 Oct 2007 13:44:22 +0200
> Hi
> I am new to SSRS and have some trouble.
> I have a report which is deployed and I can show this report
> in a project ( asp.net Framework vs. 2 ) using
> Microsoft.Reporting.WebForms.ReportViewer.
> Thats fine, but now I have to make up some code for changing the
> Query used in my datasets:
> I need to get my sql, and modify it ( put on some "Where... ", "exists()",
> and so on ) - then put the sql back in the report and then execute/show
the
> report.
> I am familiar with parameters, but parameters can't cover my needs.
> I've googled and found a lot of stuff, but I can't find any examples -
maybe
> it is because I don't know which words to use, or how to filter the
> information
> Hope somebody can help
> Thanks
> Christina
>
>|||Chris Alton [MSFT] wrote:
> I don't believe you can do that when the ReportViewer is in "Remote"
> mode but in "Local" mode you are the one that supplies the DataSource
> to report so you can execute whatever queries you want and then pass
> the DataSource into the report by doing
> ReportViewer.LocalReport.DataSources.Add.
> You can find a lot of good examples and information for ReportViewer
> here: http://www.gotreportviewer.com/
hmm, but thanks anyway :-)
Christina
I am new to SSRS and have some trouble.
I have a report which is deployed and I can show this report
in a project ( asp.net Framework vs. 2 ) using
Microsoft.Reporting.WebForms.ReportViewer.
Thats fine, but now I have to make up some code for changing the
Query used in my datasets:
I need to get my sql, and modify it ( put on some "Where... ", "exists()",
and so on ) - then put the sql back in the report and then execute/show the
report.
I am familiar with parameters, but parameters can't cover my needs.
I've googled and found a lot of stuff, but I can't find any examples - maybe
it is because I don't know which words to use, or how to filter the
information
Hope somebody can help
Thanks
ChristinaI don't believe you can do that when the ReportViewer is in "Remote" mode
but in "Local" mode you are the one that supplies the DataSource to report
so you can execute whatever queries you want and then pass the DataSource
into the report by doing ReportViewer.LocalReport.DataSources.Add.
You can find a lot of good examples and information for ReportViewer here:
http://www.gotreportviewer.com/
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> From: "Chrisser" <cbj@.egdatainform.dk>
> Newsgroups: microsoft.public.sqlserver.reportingsvcs
> Subject: 2005 Reporting service - change commandtext runtime from .net
> Date: Thu, 4 Oct 2007 13:44:22 +0200
> Hi
> I am new to SSRS and have some trouble.
> I have a report which is deployed and I can show this report
> in a project ( asp.net Framework vs. 2 ) using
> Microsoft.Reporting.WebForms.ReportViewer.
> Thats fine, but now I have to make up some code for changing the
> Query used in my datasets:
> I need to get my sql, and modify it ( put on some "Where... ", "exists()",
> and so on ) - then put the sql back in the report and then execute/show
the
> report.
> I am familiar with parameters, but parameters can't cover my needs.
> I've googled and found a lot of stuff, but I can't find any examples -
maybe
> it is because I don't know which words to use, or how to filter the
> information
> Hope somebody can help
> Thanks
> Christina
>
>|||Chris Alton [MSFT] wrote:
> I don't believe you can do that when the ReportViewer is in "Remote"
> mode but in "Local" mode you are the one that supplies the DataSource
> to report so you can execute whatever queries you want and then pass
> the DataSource into the report by doing
> ReportViewer.LocalReport.DataSources.Add.
> You can find a lot of good examples and information for ReportViewer
> here: http://www.gotreportviewer.com/
hmm, but thanks anyway :-)
Christina
2005 Report Viewer webpart
Hi,
Hasn't see anybody talk about this issue.
1. I drag a Report Viewer webpart in WSS site and edit its' "Title" then
close the "Modify Shared Page"
The Title change to "Report Viewer".
2. I click the "Modify Shared Web Part" of Report Viewer and change the
title.
It can change the title but when I click "Modify Shared Page", the title
change to "Report Viwer".
So, what's wrong with RS 2005 Webpart?
It's my problem or RS 2005 webpart?
Thanks for any advice!
Angiwhere did you get your report viewer webpart for SRS 2005 '
Thanks
"angi" wrote:
> Hi,
> Hasn't see anybody talk about this issue.
> 1. I drag a Report Viewer webpart in WSS site and edit its' "Title" then
> close the "Modify Shared Page"
> The Title change to "Report Viewer".
> 2. I click the "Modify Shared Web Part" of Report Viewer and change the
> title.
> It can change the title but when I click "Modify Shared Page", the title
> change to "Report Viwer".
> So, what's wrong with RS 2005 Webpart?
> It's my problem or RS 2005 webpart?
> Thanks for any advice!
> Angi
>
>
Hasn't see anybody talk about this issue.
1. I drag a Report Viewer webpart in WSS site and edit its' "Title" then
close the "Modify Shared Page"
The Title change to "Report Viewer".
2. I click the "Modify Shared Web Part" of Report Viewer and change the
title.
It can change the title but when I click "Modify Shared Page", the title
change to "Report Viwer".
So, what's wrong with RS 2005 Webpart?
It's my problem or RS 2005 webpart?
Thanks for any advice!
Angiwhere did you get your report viewer webpart for SRS 2005 '
Thanks
"angi" wrote:
> Hi,
> Hasn't see anybody talk about this issue.
> 1. I drag a Report Viewer webpart in WSS site and edit its' "Title" then
> close the "Modify Shared Page"
> The Title change to "Report Viewer".
> 2. I click the "Modify Shared Web Part" of Report Viewer and change the
> title.
> It can change the title but when I click "Modify Shared Page", the title
> change to "Report Viwer".
> So, what's wrong with RS 2005 Webpart?
> It's my problem or RS 2005 webpart?
> Thanks for any advice!
> Angi
>
>
Subscribe to:
Posts (Atom)