Problem rendering Reports with sub-reports to CSV

Hi, all.

Hope all is well with you. I have a Q re Reporting Services, hope someone can help me out. My setup: SQL Server Reporting Services 2000 SP 2, running in W2K3, Visual Studio 2003.

I have a report made up of a few sub-reports, stacked on top of each other. When I render the main report in Report Manager (HTML), the sub-reports comes out on top of each other as designed in the Layout, similarly when I export it to PDF.

However, when I export the main report to CSV, all of the sub-reports come out next to each other, rather than on top of each other, as originally designed.

Does anyone know how to overcome this problem?

Thank you very much.

Cliff.

Unfortunately the CSV renderer is not at all a layout renderer -- it just emits the data without too much regard for layout.|||

So, are you saying that there's probably no way around this problem?

Thanks.

Problem Rendering report via URL

Here's the link:
http://dvws02ms.firm.jonesday.dv:800/Reports/Pages/Report.aspx?ItemPath=%2fCLE+Reports%2ftest&rs:Command=Render&Type=O
My report is called test and it has one report parameter, Type. Somehow if
just keeps prompting me that the parameter is missing. Anybody had problems
with this before? This is the first report I've tried to run with a
parameter through a URL. RS2005............I figured this out. I wasn't pointing to the ReportViewer.aspx page...
"gdjoshua" wrote:
> Here's the link:
> http://dvws02ms.firm.jonesday.dv:800/Reports/Pages/Report.aspx?ItemPath=%2fCLE+Reports%2ftest&rs:Command=Render&Type=O
> My report is called test and it has one report parameter, Type. Somehow if
> just keeps prompting me that the parameter is missing. Anybody had problems
> with this before? This is the first report I've tried to run with a
> parameter through a URL. RS2005............

Problem printing reports

Hello,

When print reports in Reporting Services 2005, the default paper is "A4", but our reports have letter size, or even "A3" or "legal". Could we set a default paper for printing for each report?

thanks,

Pablo Orte

Can't anybody help me?

:-/

|||In the layout tab of the report designer, right click on an area outside your report and select properties. Then, set the height, width, and margins.

I hope this helps.

TF|||

This is already done, but when you want to print the report the page is still "a4"

Thanks

|||

Try to change the paper size in Report > Report Properties. Then Click on the LayOut tab. There you can just indicate the Page Width and Page Height of your report.

Hope this helps..

|||

Hum... what part of "already done" don′t you understand?

The size is correct when I export to PDF, but the print paper doesn′t change.

|||Well.. if that doesnt work, maybe you can just try adjusting your fields or tables.. to accomodate the paper size you prefer.. because, maybe the paper size is correct but maybe you have a very big table.. Try to adjust the fonts size and/or the table margins..|||The size, margins, and textboxes/table size are correct, but the default paper when you click on "print" is "A4", when the report size is much bigger.|||

What about changing the paper orietation.. like from portrait to landscape or vise versa.. you can do that by interchanging the width size and height size..

Sorry but im out of ideas..

|||The orientation has been changed too, it is in landscape. Don't worry.|||

I have the same problem. Its as if SRS doesn't communicate with the printer.

|||

We solved it. It was a printer drivers problem.

Our customers could print with the rigth paper in ther PCs.

Problem printing reports

Hello,

When print reports in Reporting Services 2005, the default paper is "A4", but our reports have letter size, or even "A3" or "legal". Could we set a default paper for printing for each report?

thanks,

Pablo Orte

Can't anybody help me?

:-/

|||In the layout tab of the report designer, right click on an area outside your report and select properties. Then, set the height, width, and margins.

I hope this helps.

TF|||

This is already done, but when you want to print the report the page is still "a4"

Thanks

|||

Try to change the paper size in Report > Report Properties. Then Click on the LayOut tab. There you can just indicate the Page Width and Page Height of your report.

Hope this helps..

|||

Hum... what part of "already done" don′t you understand?

The size is correct when I export to PDF, but the print paper doesn′t change.

|||Well.. if that doesnt work, maybe you can just try adjusting your fields or tables.. to accomodate the paper size you prefer.. because, maybe the paper size is correct but maybe you have a very big table.. Try to adjust the fonts size and/or the table margins..|||The size, margins, and textboxes/table size are correct, but the default paper when you click on "print" is "A4", when the report size is much bigger.|||

What about changing the paper orietation.. like from portrait to landscape or vise versa.. you can do that by interchanging the width size and height size..

Sorry but im out of ideas..

|||The orientation has been changed too, it is in landscape. Don't worry.|||

I have the same problem. Its as if SRS doesn't communicate with the printer.

|||

We solved it. It was a printer drivers problem.

Our customers could print with the rigth paper in ther PCs.

Problem print report from vb app

we have a vb app that displays reports yet when you try and print the report it either doesn't do so (although it appears to queue it) or it prints but with info missing and control info in odd spots. Anyone have any clues as to how to resolve this? My reports do me no good if the developers can't make the apps access them via the applications they are developing.Do you use Report Viewer control to display reports?

problem opening data connection

Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
someone else created. I'm not very familiar with either RS or VS. When I go
into VS and load the solution (someone told me how to find the correct one)
and then in the solution explorer, I double click on the report that I want
to change. Then I click on the "Data" tab and I get this error:
"A connection cannot be made to the database. Set and test the connection
string. SQL Server does not exist or access denied." I double clicked on the
rds file under "Shared Data Sources" and looked on the General tab. This is
the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
think the contractor developed on his local machine and then deployed to the
development server. I don't have RS on my machine. Will it hurt anything if
I change the connection string to point to the development server?
Thanks,
--
Dan D.No problem check all the parameters and most importantly select the server
and database and user / password. it should work..
Amarnath
"Dan D." wrote:
> Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> someone else created. I'm not very familiar with either RS or VS. When I go
> into VS and load the solution (someone told me how to find the correct one)
> and then in the solution explorer, I double click on the report that I want
> to change. Then I click on the "Data" tab and I get this error:
> "A connection cannot be made to the database. Set and test the connection
> string. SQL Server does not exist or access denied." I double clicked on the
> rds file under "Shared Data Sources" and looked on the General tab. This is
> the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> think the contractor developed on his local machine and then deployed to the
> development server. I don't have RS on my machine. Will it hurt anything if
> I change the connection string to point to the development server?
> Thanks,
>
> --
> Dan D.|||Thanks.
If I create a new data source and a new report in the same solution, how do
I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
files and upload them to the reports folder? Or is the rds file incorporated
in the rdl file and I just have to upload the rdl file?
Thanks,
--
Dan D.
"Amarnath" wrote:
> No problem check all the parameters and most importantly select the server
> and database and user / password. it should work..
> Amarnath
>
> "Dan D." wrote:
> > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > someone else created. I'm not very familiar with either RS or VS. When I go
> > into VS and load the solution (someone told me how to find the correct one)
> > and then in the solution explorer, I double click on the report that I want
> > to change. Then I click on the "Data" tab and I get this error:
> > "A connection cannot be made to the database. Set and test the connection
> > string. SQL Server does not exist or access denied." I double clicked on the
> > rds file under "Shared Data Sources" and looked on the General tab. This is
> > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > think the contractor developed on his local machine and then deployed to the
> > development server. I don't have RS on my machine. Will it hurt anything if
> > I change the connection string to point to the development server?
> >
> > Thanks,
> >
> >
> > --
> > Dan D.|||If you deploy the rdl from VS2003 it will automatically deploy the rds, if it
hasn't been deployed before. The default is not to allow deployed rds to be
overwritten.
You can also deploy both the rds and rdl by uploading from the Report Manager.
HTH,
magendo_man
"Dan D." wrote:
> Thanks.
> If I create a new data source and a new report in the same solution, how do
> I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> files and upload them to the reports folder? Or is the rds file incorporated
> in the rdl file and I just have to upload the rdl file?
> Thanks,
> --
> Dan D.
>
> "Amarnath" wrote:
> > No problem check all the parameters and most importantly select the server
> > and database and user / password. it should work..
> >
> > Amarnath
> >
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > into VS and load the solution (someone told me how to find the correct one)
> > > and then in the solution explorer, I double click on the report that I want
> > > to change. Then I click on the "Data" tab and I get this error:
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. SQL Server does not exist or access denied." I double clicked on the
> > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > think the contractor developed on his local machine and then deployed to the
> > > development server. I don't have RS on my machine. Will it hurt anything if
> > > I change the connection string to point to the development server?
> > >
> > > Thanks,
> > >
> > >
> > > --
> > > Dan D.|||If you have VS 2003 that's well and good since it does everything for you,
when you just click "deploy". When you deploy all the details are stored in
tables in an encrypted form so just copying is not the solution.. Other way
is through scripts. using RS.exe
Let me know if you require it or just go to sample.RSS at
\Samples\Reporting Services\Script Samples and select publishsample report.
Just see how to publish a report and you can change accordingly.
Amarnath
"Dan D." wrote:
> Thanks.
> If I create a new data source and a new report in the same solution, how do
> I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> files and upload them to the reports folder? Or is the rds file incorporated
> in the rdl file and I just have to upload the rdl file?
> Thanks,
> --
> Dan D.
>
> "Amarnath" wrote:
> > No problem check all the parameters and most importantly select the server
> > and database and user / password. it should work..
> >
> > Amarnath
> >
> >
> > "Dan D." wrote:
> >
> > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > into VS and load the solution (someone told me how to find the correct one)
> > > and then in the solution explorer, I double click on the report that I want
> > > to change. Then I click on the "Data" tab and I get this error:
> > > "A connection cannot be made to the database. Set and test the connection
> > > string. SQL Server does not exist or access denied." I double clicked on the
> > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > think the contractor developed on his local machine and then deployed to the
> > > development server. I don't have RS on my machine. Will it hurt anything if
> > > I change the connection string to point to the development server?
> > >
> > > Thanks,
> > >
> > >
> > > --
> > > Dan D.|||Thanks.
--
Dan D.
"magendo_man" wrote:
> If you deploy the rdl from VS2003 it will automatically deploy the rds, if it
> hasn't been deployed before. The default is not to allow deployed rds to be
> overwritten.
> You can also deploy both the rds and rdl by uploading from the Report Manager.
> HTH,
> magendo_man
> "Dan D." wrote:
> > Thanks.
> >
> > If I create a new data source and a new report in the same solution, how do
> > I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> > files and upload them to the reports folder? Or is the rds file incorporated
> > in the rdl file and I just have to upload the rdl file?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Amarnath" wrote:
> >
> > > No problem check all the parameters and most importantly select the server
> > > and database and user / password. it should work..
> > >
> > > Amarnath
> > >
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > > into VS and load the solution (someone told me how to find the correct one)
> > > > and then in the solution explorer, I double click on the report that I want
> > > > to change. Then I click on the "Data" tab and I get this error:
> > > > "A connection cannot be made to the database. Set and test the connection
> > > > string. SQL Server does not exist or access denied." I double clicked on the
> > > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > > think the contractor developed on his local machine and then deployed to the
> > > > development server. I don't have RS on my machine. Will it hurt anything if
> > > > I change the connection string to point to the development server?
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > --
> > > > Dan D.|||I was able to make a change to the report and deploy it using the browser. I
didn't need to make a change to the rds file so I didn't need to redeploy it.
Thanks,
--
Dan D.
"Amarnath" wrote:
> If you have VS 2003 that's well and good since it does everything for you,
> when you just click "deploy". When you deploy all the details are stored in
> tables in an encrypted form so just copying is not the solution.. Other way
> is through scripts. using RS.exe
> Let me know if you require it or just go to sample.RSS at
> \Samples\Reporting Services\Script Samples and select publishsample report.
> Just see how to publish a report and you can change accordingly.
> Amarnath
>
> "Dan D." wrote:
> > Thanks.
> >
> > If I create a new data source and a new report in the same solution, how do
> > I deploy it? If I don't use VS2003 to deploy do I take both the rds and rdl
> > files and upload them to the reports folder? Or is the rds file incorporated
> > in the rdl file and I just have to upload the rdl file?
> >
> > Thanks,
> > --
> > Dan D.
> >
> >
> > "Amarnath" wrote:
> >
> > > No problem check all the parameters and most importantly select the server
> > > and database and user / password. it should work..
> > >
> > > Amarnath
> > >
> > >
> > > "Dan D." wrote:
> > >
> > > > Using SS2000, RS2000, VS2003. I'm trying to make changes to some reports that
> > > > someone else created. I'm not very familiar with either RS or VS. When I go
> > > > into VS and load the solution (someone told me how to find the correct one)
> > > > and then in the solution explorer, I double click on the report that I want
> > > > to change. Then I click on the "Data" tab and I get this error:
> > > > "A connection cannot be made to the database. Set and test the connection
> > > > string. SQL Server does not exist or access denied." I double clicked on the
> > > > rds file under "Shared Data Sources" and looked on the General tab. This is
> > > > the connection string "data source=localhost;initial catalog=SMCLMS_Dev. I
> > > > think the contractor developed on his local machine and then deployed to the
> > > > development server. I don't have RS on my machine. Will it hurt anything if
> > > > I change the connection string to point to the development server?
> > > >
> > > > Thanks,
> > > >
> > > >
> > > > --
> > > > Dan D.sql

Problem listing data

Please tell me what I am doing wrong. I have some problems using Crystal Reports. I have for an example an Access database with a table called "Authors". I connect to the database using the server explorer in VS.NET 2005, I create an OleDbConnection and a DataAdapter. I use the Generate Dataset option from the DataAdapter to generate a Typed DataSet called dataSet1. I load data into the DataSet using the Fill method from the DataAdapter. Then I insert a new Crystal Report Document Using the Wizard and I add as data source From the Project Data/ADO.Net Datasets the dataset1.Authors. I add all the fields from the dataset and I add an Crystal Report Viewer control to the main form. I use the folowing code to set the ReportSource filed of the viewer:

CrystalReport1 cs = new CrystalReport1();
this.crystalReportViewer1.ReportSource = cs;

Ok, when I run the Application the Crystal Report Viewer it lists nothing from the DataSet data. What is wrong?I found a solution by adding a magic line of code:

CrystalReport1 cs = new CrystalReport1();
cs.SetDataSource(this.dataSet11);//here it is!
this.crystalReportViewer1.ReportSource = cs;

Problem in web reporting

Hi,
Using CR9 and ASP to publish the reports in web. Using the sample code given by the crystal decisions.com. How many sessions/users it will support at a time?
Sometimes, my reports are too to slow
Have idea, pls help me
ThanksDear friend,
It's not a reply to ur question that you put long back...But I'm facing the same problem today...Actually I'm new in ASP...I'm trying to get a report from the data of my table...I just could not get any idea...If you got will you help with the part of coding...I mean how you connected to CR from ASP and got report...I'm using ASP in Visual Interdev and SQL server 2000 as backend

Problem in Web Reporting

Hi,

I'm using CR 9 RDC objects with ASP to publish the reports in the web. Works fine.

The problem is while trying to generate a complex report which takes few mins to open, I can't open other reports at the same time. No error in Creating the report object. But raises

"Crystal Report job Failed. A Free license coundn't be obtained in the allocated"

in the statement

session("oRpt").ReadRecords

If you have any idea please help me

Thanks.Hi ,
Could you please take a look at the problem I have posted today ( under Crystal Reports + ADO title ., It is a strange problem I am facing and hav'ent been able to find a solution so far , I noticed that you have helped quite a few guys in Crystal reports- hence this message to you !
Thanks for any help !