Friday, March 9, 2012
Dynamic display of SQL in Excel?
Can anyone provide any pointers how I might go about building a spreadsheet that could caputure/display this data automatically?
Thanks.See if under Data menu...Import External Data...New Web Query
Not sure of the particulars but it would get you started.
Originally posted by shadowplayer
I have WebTrends web site traffic analysis running nightly on a SQL DB server. Every month, I must hit over 50 report URLs (pages use frames) to manually caputure 3 numbers into an Excel spreadsheet.
Can anyone provide any pointers how I might go about building a spreadsheet that could caputure/display this data automatically?
Thanks.|||Thanks for your reply. That's exactly what I ended up doing. Found it by accident when I noticed the "little yellow box" that appeared when I cut & pasted data from the webpage into my spreadsheet.
I just saved the qry file and opened it in notepad to config the values.
This will save me HOURS of work.
VERY cool.
Thanks again for your reply!
Wednesday, February 15, 2012
Dynamic (Parameterized) Page-Breaks
Hi,
I have a report, where depending on a parameter-value (e.g. Change in day: Yes/No), I need to display the records in one page or multiple pages (i.e. If Change in Day = Yes, display the records for each day in different pages. If No, display all the records in one page). In-short page break for each day, if there is a change in day, else no page break.
Can anyone suggest, is this possible to do with SSRS 2005 RTM ? I had read somewhere that conditional page-breaks is not supported. But, is there any other way I can do this ?
Thanks in Advance.
Isnt there a way to achieve this ?
Its URGENT. Any help is highly appreciated.
|||you need to create a dummy group with "page break at end" true for this and the expression for group will be set according to parameter value
like if user has selected "Yes" then set group expression
=iif(parametrvalue=yes,<fieldname-day>,1)
try this, it should work.
|||Thanks a lot. It worked.
Thanks again.
|||but be careful it will work only if you have only one group in report. If you add more then it won't work.|||How to implement Page break if we are having more than one groupDynamic (Parameterized) Page-Breaks
Hi,
I have a report, where depending on a parameter-value (e.g. Change in day: Yes/No), I need to display the records in one page or multiple pages (i.e. If Change in Day = Yes, display the records for each day in different pages. If No, display all the records in one page). In-short page break for each day, if there is a change in day, else no page break.
Can anyone suggest, is this possible to do with SSRS 2005 RTM ? I had read somewhere that conditional page-breaks is not supported. But, is there any other way I can do this ?
Thanks in Advance.
Isnt there a way to achieve this ?
Its URGENT. Any help is highly appreciated.
|||you need to create a dummy group with "page break at end" true for this and the expression for group will be set according to parameter value
like if user has selected "Yes" then set group expression
=iif(parametrvalue=yes,<fieldname-day>,1)
try this, it should work.
|||Thanks a lot. It worked.
Thanks again.
|||but be careful it will work only if you have only one group in report. If you add more then it won't work.|||How to implement Page break if we are having more than one group