Hi,
We've been using the ReportService.asmx?wsdl to generate a web service stub
code and it worked fine, but when we switched to the
ReportService2005.asmx?wsdl entry it's not generating the above mentioned
methods (GetReportDataSources, SetReportDataSources). Are they obsolete now?
Please advise.
Best regards,
MikeI got it. Methods renamed to GetItemDataSources and SetItemDataSources.
"mike" wrote:
> Hi,
> We've been using the ReportService.asmx?wsdl to generate a web service stub
> code and it worked fine, but when we switched to the
> ReportService2005.asmx?wsdl entry it's not generating the above mentioned
> methods (GetReportDataSources, SetReportDataSources). Are they obsolete now?
> Please advise.
> Best regards,
> Mikesql
Showing posts with label generate. Show all posts
Showing posts with label generate. Show all posts
Monday, March 26, 2012
Friday, March 9, 2012
Get the complete SQL Query
Hi !!!
I was told to generate in HTML the content of a crystal report, but without using Crystal Reports... The report is feeded from a sql server view, but inside the report there are many grouping and summarizing fields, so it's very difficult for me to build the sql query to feed my HTML report...
I'd like to know if there's a way to obtain (programatically or not) the complete SQL statement (that is, the original query from datasource plus any modification done in the crystal report such as grouping and summarizing).
Thank you !!!if u have crystal reports installed, open rpt file and
click database menu select show sql query.
U can see the rpt query.
regarding summary fields, u need to find it in rpt, in group footers or group headers.
Hope it helps|||Thank you sraheem !
The "show sql query" just shows the datasource sql query, but not the final sql that is built using that datasource AND grouping and summarizing fields...
Maybe it's not possible to obtain that final sql query ?
Thanks for help !
I was told to generate in HTML the content of a crystal report, but without using Crystal Reports... The report is feeded from a sql server view, but inside the report there are many grouping and summarizing fields, so it's very difficult for me to build the sql query to feed my HTML report...
I'd like to know if there's a way to obtain (programatically or not) the complete SQL statement (that is, the original query from datasource plus any modification done in the crystal report such as grouping and summarizing).
Thank you !!!if u have crystal reports installed, open rpt file and
click database menu select show sql query.
U can see the rpt query.
regarding summary fields, u need to find it in rpt, in group footers or group headers.
Hope it helps|||Thank you sraheem !
The "show sql query" just shows the datasource sql query, but not the final sql that is built using that datasource AND grouping and summarizing fields...
Maybe it's not possible to obtain that final sql query ?
Thanks for help !
Subscribe to:
Posts (Atom)