Place it in query anylsizer and run it one statement at a time.
Lots wrong with your SP, You have to check the #temp table fields match your field form your other tables This should work; Syntax checked OK...
" Reporting Service. Error is : Invalid object name temptable." Are you creating a real temp table i.e. with # at the start, if you are you have...
OK sample of simple rollup getting YTD (year to date) and PYTD (previous year to date) from an orders table. I've not checked or parsed code so...
I created a report and its fine, but when I add an additional group with a drill down it has unexpected page breaks when the drill down is collapsed....
You have to create #temp table before you can insert / access try something like this ============================ CREATE PROCEDURE...
quote:Originally posted by dougwood No, the tables are coming from 2 completely different Oracle DB's on different servers. This leads me to my next...
Pass the Parameters to a back End Stored Procedure and use a SQL to group them
Had the same problem with percentage values on a report for sub/totals VarA , VarB, DiffA Create a new field called DiffA = ((Fields!MTD.VarA) -...
1. Does anyone know how to stop render the report if pass in the parameters in the URL? for...
Sounds like your url is not correct for accessing the page. Check network / machine settings to see of internal DNS matches external DNS etc.. Try...
you are trying to do a rollup of data ? Rollup ======= 1) create a sp 2) In the sp create a #temp table 3) insert into #temp with your various...
Separate names with a comma.
