Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net have generously sponsored dedicated servers to ensure a reliable and scalable dedicated hosting solution for BigResource.com.





Having Two Datasets In A Single Report


Hi,

 i have developed a report with sql reporting services 2005 which consists of two datasets in the same report.

Any performance issues it will cause?

Thanks,

Shanthi

 

 

 




View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Differentiate Between Fields Of TWO Datasets In A Single Report
 

Dear ppl,

I have got 2 datasets D1 & D2 in a Report. How can i differentiate between the fields of these two.

e.g. I got Name field in both the datasets. So when i do =Fields!Name.Value in a textbox the report gives me error

How can i tell the report from which dataset to pick up the field ??

Regards

Nabeel

 

 

View Replies !   View Related
Two Different Datasets In A Single Table.
 

Hi,
 
I need to display the datas in a table format. I have placed a table and now i need to use two different datasets for a single table. Those two different datasets are generated based on two different stored procedures. Those stored procedures retrieve data from two different sql tables. Can any one explain me how to use two different datasets for a single table. As far i have tried i was able to fetch only the first record of the other dataset. But i need to fetch all the records of both the dataset. Thanks in advance for any help.
 
Thanks,
Sangeethaa

View Replies !   View Related
Multiple Datasets In A Single Chart?
Is it possible to incorporate data from 2 datasets into a single chart?  For example I have 1 set of data from 1 db which allows me to display datapoint "A" by week. I have a second dataset from another db which allows me to display datapoint "B" by week. I'd like to plot each of these separate datapoints on a single chart with the x axis being week and the y axis being a stacked bar chart incorporating both A and B values as individual data series. Further, assuming this is possible, is it then possible to have 1 series displayed as an area while the 2nd series is a column or line?

View Replies !   View Related
Using Two Datasets In A Report
hello everyone!
 
i have a report in which i use two datasets
the problem is that when i was using only one, there wasn't any scope argument you know, to tell in which dataset i am , because there was only one and all fields and cells in my table returned me the correct values
 
but as soon as i add the second data set and i drag and drop the datasets fields in my table
 
instead of having for instance



Code Snippet
 
=Fields!Consultant.Value
 
 




or
 



Code Snippet=(Fields!Consultant.Value, "dataset1")
 
 


 
it automtically applies the function "first"
 



Code Snippet=First(Fields!Consultant.Value, "dataset1")
 
 


 
and i don't understand why
 
please can you give me precious help on this
 
because it returns me the name of the first consultant only and if i deleter the function first in the expression, the report doens't work anymore

View Replies !   View Related
2 Datasets In One Report?
Dear Experts,
 
I have a problem regarding my report.
 
Can we use 2 datasets in one report (tabular or chart, either one)?
 
my report get its data-fed from OLAP database (Cubes) and Oracle tables.
 
Let say the cube contains the actual sale (all aggregated and query using MDX) and the Oracle table contains the budget value for specific period.
 
And I am trying to construct a tabular like this:
 
date         item      type       Revenue      Budget      Actual (Sale - Budget)
Jan          calls      regular    2000           1800            200
Jan          calls      super      3000           2500           500
Feb          calls      new        1000           900             100
Mar          calls      super       4500          4000            500
..... and so on
 
The data for date, item, type and Revenue are available in the OLAP (cubes) and the Budget value is available in Oracle table and we can't afford to transfer the Budget value to the cube.
 
Is this possible in SSRS? Please let me know if more information needed.
 
Thanks very much

View Replies !   View Related
How To Get Results From 2 Datasets Into Report
Im trying to use 2 datasets in a report. The first one works ok, but when I add another one (a different table from the same database), it runs ok and brings up results in the data tab, but when I try to view it on the preview tab I get the following error:
 
an error occured during local report processing.
The definition of the report '/PI' is invalid.
The data set name is missing in the data region 'Dataset2'.
 
any ideas?
The queries i am running are simple SELECT * queries.
 
 

View Replies !   View Related
Problems Addressing Different Datasets Used In One Report
Take a look at my report in layout view:

http://img366.imageshack.us/my.php?image=unbenanntex1.png

My problem is that the left table works perfectly, the right one always sums all values and uses the first funtion on char-fields... I never encountered the problem before, is there an easy solution for this?

View Replies !   View Related
Execute Two Datasets Simultaneosly For One Report
Hi,
    I have a scenario, where I have to execute a procedure and then run a query to get rows from a table. Whenever the user clicks on view report, these two should happen.
 So I came with a strategy like, I have kept two datasets, one for executing SP and one for executing select query.
Can I run these two datasets one after the other, when view report was clicked?
 
Any other ideas?
 

View Replies !   View Related
Two Different Datasets With Same Field Names Used In Same Report
I am having two datasets in the same report, the column names are the same, in both the datasets, Now How can I use the individual fields in same report.
If I use (Fields!xyz.Value, "dsDataSet1") and (Fields!xyz.Value, "dsDataSet2")
It is giving me syntax error.
 
How can I use both these fieds, I do not want any aggregates

View Replies !   View Related
Report With 2 Datasets (Formatting Question)
I have a report with two datasets(and two tables). They both have a field in common(a customer code).

I want the results to be one customer per page.
This isn't a problem when using one dataset, because I can just group by customer_code and page break at the end.

But in this case I need the customer info from the second dataset to be on the same page as the customer info from the first set.

Does anyone have any formatting tips on this?

View Replies !   View Related
Problem Using Stored Procedures In Report Datasets
I have a local Reporting Services report that I am modifying to use a stored procedure.

 

Although I am executing a stored procedure in the dataset query window, I also have to run a SELECT statement to retrieve the fields from a table that will populate the report.

 

The code that I have in the dataset query window looks like the following:

 

------------------------------------------------------------------------------------------------------------

EXECUTE @retCode = RunClaimVerification @parmID, @parmDate, @parmRecordID OUTPUT

 

SELECT *

FROM ClaimsDetail

WHERE ClaimRecordID = @parmRecordID

------------------------------------------------------------------------------------------------------------

 

When I execute this code, the only results that are returned SEEM TO BE the return code associated with running the stored procedure.

 

I thought about putting the SELECT code in the stored procedure and returning a table or a cursor from the stored procedure BUT it looks like tables are not supported as Report Parameter data types.

 

The stored procedure code generates Claim data that is stored in a SQL Table.  The fields in this SQL table need to be retrieved by a unique record id to populate the fields in the report.

 

Does anybody have any suggestions as to how to go about doing this OR any suggestions that would help me resolve this problem?

View Replies !   View Related
Payslip Report With Multiple Tables/datasets
A report I am currently working on is a payslip report.
This report has multiple tables on the page, each linked to their own specific dataset.
Eg I have Taxable Allowances table linked to a dataset that returns information relating to any taxable allowances for an employee, then Non-Taxable allowances, Deductions and so on...
 
Taxable allowance dataset example
 
SELECT
  TA.TaxableTrDesc,
  TA.TaxableTrText,
  TA.TaxableSubQty,
  TA.TaxableTrRate,
  TA.TaxableTrFact,
  TA.TaxableSubTtl
FROM
  Employee E
  INNER JOIN TransCurrentMaster TCM ON E.EmployeeCode = TCM.EmployeeCode
  CROSS APPLY udfReportTaxableAllowances(E.EmployeeCode, TCM.PaySequence, ) TA
WHERE
  E.EmployeeCode IN (@EmployeeCodeParameter)
  AND TCM.PaySequence IN (@PaySequenceParameter)
 
The report works fine when you select one employee.
Currently when you try to select more than one employee, all the employee results are displayed in the tables, for example, Taxable Allowance table contains all taxable allowances records for all employees on the one page...
I'm not sure how I can amend this report so that it is able to be run for multiple employee records...
Any ideas, thoughts, feedback would be much appreciated..
 
Cheers
 

View Replies !   View Related
Multi-table DataSets In VS2005 SRS Report Designer
Hi all,

 

I need to use a multi-table dataset as a datasource for my report items in a SRS2005 report.

But from designer, I can only see the first table.

 

Can any one tell me if it is possible to use multiple tables in a dataset for SRS report?

 

Thanks,

 

Samson

View Replies !   View Related
Reporting Services : Report Using Two Datasets From Two SSAS Cubes
Hi,

I would like to build an SSRS report from two different cubes (SSAS 2005). These cubes are contained in two different SSAS databases.

To do this, i created a dataset for each cube throught MDX expressions.
These datasets use common parameters defined in my report.
Thus, i try to integrate in my report chart  datas from the two datasets, but my chart only target one dataset.

Is it possible to create a kind of dataset view to join my two datasets ?
Or is it possible to join the cubes from two different SSAS databases in an MDX expression to put all my datas in a single dataset ?

thx for your help.

Zohir

View Replies !   View Related
How To Create A Report By Processing Multiple Datasets In The XML Returned By A Web Service?
 
 
HI!
 
I need you to look at the problem and try to work to find a solution.This is very urgent for me.
 
Problem Statement:
 
Performance Reports (a category of reports ) will use XML as a datasource.  There will be a call to Web Service which will in turn return an XML file.  Presently the XML return only one DataSet and that is used to generate the report.
 
Going forward the XML will be returning more than one DataSet. 
 
Action to be taken:
 
Presently we are able to process the XML with one Dataset and don€™t know how to process if it has multiple DataSets.
 
Can any one help me how to do it in .,i.e..How to create a report by processing multiple datasets in the XML returned by a web service?
 

View Replies !   View Related
Multi-value Parameter In Master Report Passing To Single Param Sub-report In A List.
Here's tricky one.
 
I have a fairly complex report that was given to me that was hard coded for single parameters.  There is a dropdown for each market (created from a query in SSRS).  The users have to run for each market each week.
 
Is there a way to use this report as a Sub-report inside a list of a master report and then use a mult-value parameter?
 
I want this multi-value parameter to build the values for the list and then run the "sub-report" for each value.
 
Essentially, I want to create a for each loop.
 
Any ideas?

View Replies !   View Related
Defining Report Datasets For Package Data From SQL Server Integration Services (SSIS)
Hi,
 
I'm using SQL 2008 Februar CTP and trying to use SSIS for Data Source as described in http://msdn2.microsoft.com/en-us/library/ms159215(SQL.100).aspx.
I've created SSIS package and preformed steps described in http://msdn2.microsoft.com/en-us/library/ms345250(SQL.100).aspx (after fixing version to 10.0.0.0).
 
Now I got next error when trying to add SSIS DataSource (in Report Designer - Visual Studio):


Error messageThe data extension SSIS could not be loaded.
 

Please help.

Matej

View Replies !   View Related
Multiple 1:N Tables In Single Report Builder Report
The version of Report Builder I have will only let me choose from a very limited range of layouts. For example, the tabular layout displays a single table on a page.

 

Is there a way to produce a report containing two tables and other fields?

 

For example, I would like to create a very simple customer report with customer name and address at the top, then a table containing all contacts I have for the the customer (a 1:N sub-table of customer) and then a second table containing all the orders from the customer (a 1:N sub-table of customer).

 

Is this possible in the current version of Report Builder or is it planned in a future relase?

 

P.S. I know this is easy in VS Report Designer but I specifically want to do this in Report Builder. The Report Designer client is simply too complex for my non-technical user base. Report Builder would be ideal.

View Replies !   View Related
Multiple Report Server Instances Sharing A Single Report Server Database
I would like to know if it is possible to have different applications on separate report servers sharing one report server database.  If so are there possible issues or ptfalls to this type of architecture?

 

Thanks,



thecoleman

 

View Replies !   View Related
Listing Datasets In Report (dataset Name, Dataset's Commands)
 

Is there any way to display this information in the report?
 
Thanks

View Replies !   View Related
Two Pagination In A Single Report.
Hello :

In a report, I want to put two table, and in every table with different pagination, that is two pagination in a single report.

Table to the right with pagination on top, and another  table to the left with another pagination.


You have ideas.

Thank you.

View Replies !   View Related
Single Report With Different XML Datasources
 

Hi,
 
Looked every where to find a solution to what I think could (should) be solved relatively easy with SSRS. I am not expert on SSRS.
 
What I am trying to accomplish is having a single report work with different XML files (with the same schema) as datasource.
 
I already created some custom code that creates another XML with all available XML-files in a certain directory and this is used as XML source for a report parameter so the end-user can select the file from a dropdown box. So far so good; only when the user has selected one of the files, that file should be used as datasource when generating the report.
 
I tried to copy over the selected file (through custom code) over the XML that is configured as datasource, obviously this does not work as the target file is in used by SSRS....
 
Can anyone help?
 
 

View Replies !   View Related
Fit A Report On One Single Page?
I have a report that is 8 pages. After I upload the report to the intranet, I always have to click on "next" to see the next page. This is very troublesome, is there a way that I can show all the data on one page so that I can look at it without having to click "next" several times?

Thanks,
Steven

View Replies !   View Related
Jump To Report && Multi Value Vs. Single Value
I have a parameterized main report that contains a link to a sub report with parameters.  Then from the sub report I have a link that takes you back to main report. If I use multi value parameters or single value parameters the links going back and forth between the two reports works just dandy, when I run it on my PC. However when I deploy the reports to the Web Server, the link going from the sub report back to the main report only works if the parameters are single select. Going from the Main to the Sub it doesn€™t matter.
 
This is the error I get using multi select parameters going from the sub report back to the main.
 
The path of the item "(null)" is not valid. The path must be less than 260 characters long and must start with slash. Other restrictions apply. (rsInvalidItemPath)
 
Any suggestions?

View Replies !   View Related
Three Daily Schedules For A Single Report
Hi,

I have been trying to figure this out for a while. I have a report that should run at 9AM, 12 Noon and 2PM every weekday. Due to the complexity of the report, I'm using snapshots. Since the lowest gap is 2 hours, I currently have it configured to create the snapshot every two hours. Since this is running all day, my servers are taking a lot of strain. In the report manager help, it suggests creating three daily schedules for the report. I cannot find a way to create more than one schedule for a report. Please let me know how I can do this. Any help will be highly appreciated.

Thanks,

Anand

View Replies !   View Related
How To Place 3 Different Charts In One Single Report
Is it possible to place Column chart, Line Chart and Pie chart in one single report with single/different datasets?

View Replies !   View Related
Single Checkbox Possible When Report Parameter Is Yes Or No?
it looks like a multi value parameter is the only kind of parameter that displays a checkbox.
 
A single checkbox for yes/no parameters are more intuitive to my users than 2 choices from a query. 
 
I tried to set the multi value attribute on such a param but at run time get errors from a couple of places  1) expressions that reference such a parameter, seemingly confused about the value field being allowed to be either an object or an integer     2) unchecking the checkbox causes a prompt demanding that a value be set.
 
Does anybody have a trick or see what I am missing in trying to make a parameter act like a single yes/no checkbox in just one line of a dropdown parameter list? 

View Replies !   View Related
Multiple Stored Procedures,single Report
Hi ,
 
I have a Report which has 8 stored procedures to get 8 resultant data sets .  the stored procedures are almost similar such that they have only difference is the where clause and column getting returned.
 
So ,every stored access same set of tables and temporary tables getting created to store some set of active data derived from big table.
 
what happening is ,when i run the stored procedures individually in query analyser ,it is taking the time which is accepatable individually,but when i keep them in the same report. it is taking the time which is equal to sum of all the times taken by the stored procedures ran individually in query analyser which is some what not acceptable
 
can anybody through an idea,what can be done here. i already thought of locks and kept set transaction isolation level read uncomitted for all the stored procedures.but the time taking is same.
 
please help me here,i am stuck
 
Thank you

View Replies !   View Related
Combining Multiple Subreports Into A Single Report
The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports.  The master report that contains them defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over producing blank pages.  Are there any work-arounds to concatenate multiple, single report PDFs into a single PDF and have page numbering too?


Thanks!

View Replies !   View Related
Report Service - Drill Down For Single Column
I need to do a drill down for single column

Example , I have Managers and employees in same table . Employyes has a link to their manager. I want to display

+ Manager1
Employee1


I can do this by a spacing. But I need to do in a tree view.

 

View Replies !   View Related
Is It Possible To Render Multiple Reports Into A Single Report ??
Hi,

I have an application wherein I need to generate a single report(possibly in PDF format) which contains more than one report. Iam using SSRS 2005. In my application Iam using report server url to render reports. The below is URL for rendering single report.

http://servername/ReportServer/Pages/ReportViewer.aspx?reportname&rs%3aCommand=Render&rs%3aFormat=HTML4.0&rc%3aToolbar=true

 

Is it possible to render multiple reports into a single report ?

Can anyone help me in this regard ?

 

Thanks,

S V Ramakrishna

View Replies !   View Related
Single Report Multiple Data Sources
I have multiple data sources that I would like to use for a single report.  The data sources are separate due to security requirements.  I have a table that I can get the Initial Catalog from.  How do I get that field from the database into the data source connection string at run time?

I saw this link here but the light bulb didn't go off:

http://technet.microsoft.com/en-us/library/ms156450.aspx

"define a query that retrieves a list of data sources at run time"

Can somebody help me out here?

TIA,
Darren

View Replies !   View Related
Unable To Print The Report At Single Click
 

We are having a weird problem. User printing a report have to press the print button twice to print a report. It is causing some problem and failing in QA too :-(.

 Please help.

View Replies !   View Related
Using Multiple Data Sources In Single Report.
I am using SQL RS 2005. I have a report that is using multiple data sources from different offices. I can add these data sources in my report but is it possible that I can select a specific data source based on a selected parameter value. In this case user from each office, select their office location and be able to see the data from their office. I would appreciate any suggestions.
Sal
 

View Replies !   View Related
How To Merge Report Output Into Single File?
Hi
 
I have read a few other posts about how to merge multiple report output files into a single document e.g. a single pdf.
There are a few approaches:
1) Generate post script files and then merge and oprint via a post script driver.
2) Generate seperate pdf files and then merge them into single document using a custom library.
 
I have a third idea and would appreciate any input:
 
Dynamically generate a RDL file that contains sub-reports, one for each report required in the final document, publish and run this as the final report. This could happen way before actually running the report i.e. the user has a tool where they select reports for a pack, tool then generates new RDL file and publishes it to sql reporting services, gets run at some later point in time.
 
Some challenges:
-Generate a table of contents with page numbering?
-Layout of sub-reports, not sure how they would be rendered across multiple pages?
-Managing parametes across sub-reports at run time.
 
Any suggestions or ideas?
 
Thanks
 
T
 

View Replies !   View Related
How To Pass Multiple Value From A Single Parameter In Sql Report
 

In my form i have a list box and i need to display paticular records of all employees I selected.So please tell me how to pass multiple values from a single parameter.
 
currently i am able to pass single value through a parameter using following code
 



osqlreport.reportViewer1.ServerReport.ReportServerUrl = new Uri("http://localhost/reportserver");

osqlreport.reportViewer1.ServerReport.ReportPath = "/employee/5_0emplyeedata";



List<Microsoft.Reporting.WinForms.ReportParameter> paramList = new List<Microsoft.Reporting.WinForms.ReportParameter>();

 

string stritem;





stritem = Convert.ToString(this.lstSelectedData.Items[0]);

paramList.Add(new Microsoft.Reporting.WinForms.ReportParameter("paraempno", stritem, false));



osqlreport.reportViewer1.ServerReport.SetParameters(paramList);

osqlreport.reportViewer1.RefreshReport();

osqlreport.Show();

 
what changes do i need to do to make it work.(lstSelectedData is my list box)

View Replies !   View Related
Adding Landscape And Portrait Subreports Into A Single Report
The goal is to produce a single PDF consisting of a number of subreports. Some are landscape, others are portrait. The subreports may also be run as independent reports. The master report defaults to the width of the widest subreport, which is landscape. This causes all portrait subreports to spill over. Your suggestions / comments are appreciated.

Thanks!

View Replies !   View Related
Exporting Report To Excel In Single Page View
Hello,
 
Is it possible to generate a report in single page view and still be able to export to Excel. By default, the Report Server generates a paged report that can easily be exported to Excel and other formats. However, based on user request I generated a single page view of the report by placing the report results table inside another "Container Table". By doing so though, I can no longer export the report to Excel and it returns the following message upon opening the excel file:
 
'Data Regions within table/matrix cells are ignored'.
 
Whats more strange is that I can export to other formats just fine but not to Excel. Any idea how to make it work with Excel as well.
 
Thanks.

View Replies !   View Related
How To Generate A Report Containing Multiple Single Page Reports
I am using SS 2005 RS. I am able to generate single page pdf reports by passing "id" as a parameter. Now I need to send multiple ids as parameter and generate one big report which would contain reports for all the ids supplied on separate pages. Is this possible? If yes, then how do i do this.

What I have tried so far is, I created new report with a list control and added single page report as a subreport to this list control and grouped this list control using id parameter. When i send multiple ids in the parameter, for example 3 ids, it generates 3 page report but only for the first id. So it generates report for the first id and repeats same report 3 times.

Thanks for your help,

View Replies !   View Related
Report Does Not Load When Single Valued Parameter Is Changed ???
Hi all,

I have a report running with both a db and Analysis services data source..When I change any of the multi-valued parameters a post-back is done and then the page is re-loaded all good. However. When I change one of the single value parameters a post-back occurs however the page said "Report parameter values must be specified before the report can be displayed. Choose parameter values in the parameters area and click the Apply button." If I THEN press APPLY the report loads perfectly with the selected option.

I have un-hidden ALL my parameters and they all seem to get values.. Does anyone have any clue what could be going wrong ?


Thanks.

View Replies !   View Related
Report Generation Using A Single Dataset, Which Combines Two Tables.
Hi,
 
I have an issue in generating the report in sql reporting services. I need to display a report in a table format. The datas of the table should be from two different sql tables. I have tried to write a stored procedure that returns two result sets from two different tables. As reporting services takes datas only from the first result set, i tried to write two different stored procedures each displays one result set. Then i have created two datasets with that two different stored procedure. Even then i cannot proceed as i was not able to use two different dataset in a single table because i was setting the datasetname to one dataset, when i try to retrieve the fields from another dataset i was able to retrieve only first and count values. Then i tried using sub reports. As sub reports for a dataregion(table) repeats for every row of the main report i was not able to fetch the correct datas. Atlast i have tried combining the query using join and wrote a single stored procedure. This stored procedure returns a single result set retrieves data from two tables satisfying the conditions. The issue i am facing with this is, the first table has only one row satisfying the condition and the second table has three rows satisfying the same condition, as i am using join query for the three rows returned by the second table the first table datas are getting duplicated for the rest of the rows in the second table. As I found using join query is the only resolution for the output which I need, and also I have to avoid the duplication of the records. Hence let me know for any solutions.
 
I have shown the sample datas that is duplicating which is indicated as bold. Phonenumber, Attemptdate and calloutcome are from first table and start time and endtime is from second table. As there are three different datas for the second table, first table datas are duplicated





Phone Number

Attempt Date

Call OutCome

Start Time

End Time


843-577-0800

2007-09-10 15:20:00.000

Contact with Prospect - Expressed Interest

15:08

15:12


843-577-0800

2007-09-10 15:20:00.000

Contact with Prospect - Expressed Interest

15:25

15:25


843-577-0800

2007-09-10 15:20:00.000

Contact with Prospect - Expressed Interest

15:26

15:27
 
Thanks for any help in advance


Thanks,
Sangeethaa

View Replies !   View Related
Calculating Percenatges On Matrix Report Form A Single Column
Hi,
 
I am sure there is a simple answer to this, but I cannot find it at the moment???
 
I have a simple data table in SQL which gives me Division, PL Measure and Value...
 








SQL Table






Division
PL_Desc
Result

A
Total Labour Costs
10

A
Total Sales (inc Machine Income)
100

B
Total Labour Costs
5

B
Total Sales (inc Machine Income)
100

C
Total Labour Costs
9

C
Total Sales (inc Machine Income)
100
 
I need to report on this and calculate a ratio, so I have pushed this into a Matrix Report but cannot work out how to get the ratio column to work???...
 








Matrix Report


???????????






Division
Total Labour Costs
Total Sales (inc Machine Income)
New Column = Labour / Sales

A
10
100
10%

B
5
100
5%

C
9
100
9%

Grand Total


24
300
8%

 
If anyone can help save me from my own stupidity!
 
Cheers, Matt

View Replies !   View Related
Passing Multiple Values To Single Report Parameter Using Cube Surce
Hello Freinds,
                    I'm facing a small problem while passing Multiple Values to a Single Report Parameter, this report is using a Cube as its source. I'm able to assign and send a single value to the report parameter but i'm not finding a way to send more than one value..
The following is the code which i am using to populate my Parameter

Dim Param(0) As Microsoft.Reporting.WebForms.ReportParameter
Param(0) = New Microsoft.Reporting.WebForms.ReportParameter("BUDASADepartment", "[BUDASA].[Department].&[Accommodation]")

In the same 'BUDASADepartment' i want to add one more value as "[BUDASA].[Department].&[Others]" but i'm not able to figure out a way of do'ing it.

Any Suggestions , Thanz !
       

                 

View Replies !   View Related
SSRS Removes Spaces And Line Breaks From Single Field Report
 

I am storing formatted data (including spaces and line breaks) in a single field in a table.
When I run a report on that field, the preview of the report is automatically removing all the extra spaces and line breaks, making the report unreadable.
When exporting the report to PDF or printing it, it shows the line breaks and spaces as expected.
 
Does anyone know how to make the report preview show the spaces and line breaks?
 

View Replies !   View Related
Report Designer - Multiple Font Types In A Single Table Cell
Does anyone know if it is possible to have text in a single table cell where the first field is formatted in italics and the second is in normal?
 
eg: = Fields!firstname.Value(as italic) & " " & Fields!lastname.Value(as normal)?
 
shidot

View Replies !   View Related
Subreport With 3 Columns Renders In Main Report As A Single Vertical Column.
I have embedded a subreport in the detail section of my report.  When I view the subreport in page preview mode it renders with three columns, but when it is rendered w/in the main report in page preview mode the 3 column layout is rendered as a single verticle column.

I've defined the columns in the Body/Columns.  I have also set the report inteactivesize and pagesize heights in an attempt to remedy the issue.  Margins are set to 0.

Any help is appreciated.

View Replies !   View Related
Mutilple Space Gets Converted To Single Space In Report Viewer Control
I am generating a Report from Sql Data Source in Sql Server 2005 and viewing the Report in Report viewer control of Visual Studio 2005.
The data in the Data Source contains string with multiple spaces (for example €œ           Test String         €œ) but when they get rendered in Report viewer control, multiple spaces gets converted to single space €? Test String €œ.
 
I tried following solutions
1) Replacing spaces with €œ&nbsp;€?
2) Inserting <pre> tag before the string and </pre> tag after the string (Also tried &lt;Pre&gt; instead of <pre>)
 
But in all the cases result is same. The Report Viewer control is showing €œ&nbsp€? instead of space and €œ<Pre>€? tag instead of preserving spaces.
 
Please provide me a solution so that spaces can be preserved in Report Viewer.
 

View Replies !   View Related
Single Page Report In SSRS Is Printing With The Second Page Blank....URGENT
 

Hi All,
          In my SSRS report. I have a report which has only one page. In preview it is showing as only 1 page but when I am printing the report. I am getting two printouts with the second page as a blank.. Please help me in printing the page that contains report. Intially I used a Page header, at that it used to print the blank page with a header only. Now as I removed the header it is printing the page without header i.e Blank Page.. So please help me in prinitng a single page that has the report. It is urgent,..
 
Thanks
dotnetdev1

View Replies !   View Related
Combine Data In Single Row From Single Table
How can i combine my data in single row ? All data are in a single table sorted as employeeno, date


Code:

Employee No Date SALARY
1 10/30/2006 500
1 11/30/2006 1000
2 10/25/2006 800
3 10/26/2006 900
4 10/28/2006 1000
4 11/01/2006 8000


Should Appear


Code:

EmployeeNo Date1 OLDSALARY Date2 NEWSALARY
1 10/30/2006 500 11/30/2006 1000
2 10/25/2006 800
3 10/26/2006 900
4 10/28/2006 1000 11/01/2006 800

PLEASE HELP I REALLY NEED THE RIGHT QUERY FOR THIS OUTPUT.

THANKS IN ADVANCE

View Replies !   View Related
Where Did The Datasets Go In .NET 2.0???
I typically use  DataAdapters and Datasets from the toolbox when connecting to a SQL database.  Since switching to VS 2005, I am not able to find (or add) these items to the tool box for web site development.
   Any ideas on how I can get them back?  Or is there a better alternative to retrieving the data so I can process it?  Any help or suggestions would be appreciated.
 
Thank you

View Replies !   View Related
What Is Better To Use For Datasets?
Hi,

 

We're moving to a new module for our reports and we want to do this new module properly, i.e., write code once where possible, and use everywhere. What would be the best option for this? I personally prefer stored procedures and functions (scalar and table), the other team members here think we should maybe use views and functions. Which would be the best considering performance and ease of use to incorporate changes (which are certainly possible due to the pace at which the clients change their minds), performance being the most preferable?

 

Thanks!!!!!!!!!!!!

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved