Search results for query: *

I didn't know that putting two datasources in the main was not supported. I don't think it would be feasible to go through and add the pubinfo code to all (over 200) views/SPs so I will try the subreport. Thanks Again!

synapse, I apologize for not being very clear with my issue. The "/" in "main view/stored procedure" is meant to be read as "OR". The reason I said main is because every report has atleast TWO views (one is v_pubinfo) or a Stored Proc. and a view (v_pubinfo). The two are NOT LINKED in the DB...

Barbara, Thanks for the help. I was thinking the same thing except do I need to use a subreport in the Report Header or can I just use the field/shared variable directly in the Report Header? We are trying to move away from subreports. Thanks, Bryan

I am using CR9 integrated into a VB.NET web app. All of our reports have a main view/stored procedure and a view called v_pubinfo which supplies personal company info such as Name, Address, and the 'logoletter' which is a character (d,f,g,t,etc.). We use the logoletter in the page header of...

Nevermind, got it. Just not thinking.

Alright guys I have the report displaying as I want EXCEPT for the sort order. Do you guys know how I can sort this report by date if my first two groups are GUIDs (Long unique ID)?

Thanks Again!

Synapse- I really appreciate your time and help. You have helped me countless times but I don't think I am being clear enough for you because I am pretty sure you know how to do this. It's still not working, it just keeps repeating Details-B for every record. The "Details-C" formula I dropped...

It's not working, it keeps repeating Detail-B even if Detail-C has no data.

I am using CR9. My report is as follows GH1 >> CustomerID - SUPPRESSED GH2 >> TransactionID - Various fields Detail-A- Conditionally Suppressed Detail-B - Essentially another "Header" section with NO DATA. I want this section to show up only once, IF there is any data in Detail-C Detail-C -...

I can't really remember. If you go to the Crystal support site and search for "export pdf" or something similar to that there is a fix where you have to install a hotfix and make a registry change. It is something like "Fieldclippings" and you set it to a value. I can't remember if that did it...

Nevermind got it.

I dunno I guess I'm stupid...I thought by moving my totals and subreport to the page footer it would screw up their values in relation to the group. Anyway, thanks it worked, I just had to create a conditional header to show up for additional pages. Is there anyway to determine if there is a...

Hello all - I am using CR9 with SQL Server 2000. My report is an invoice and has the details section split into A and B. B is suppressed based on a condition and A is to display the normal records. Group Footer is split as well with GF1-A holding a subreport. GF1-B essentially serves as a...

Oh i figured it out, I knew it was something simple: you just give the parameter the value of DBNull.Value in VB.NET. Thanks!

I use SQL Server 2000 and VB.NET in my ASP.NET app. I am trying to insert data of type 'image', along with other data by using a stored procedure with parameter type of 'image'. I can insert the data just fine if I provide a legitimate path to an image. In other words, I know how to insert...

Thanks again LB!

LB - When I view the report in the designer, the formula shows up correctly (I changed the date order): 20060101-1 However, If I view the report over the web, through my custom app it shows up as 20060101-1.00. Any idea why it is adding the 2 decimal places? If I just put the "counter"...

Thank you LB, once again you have come through. I really hope they pay you for this. Only thing I had to do was a Cstr on the 'cnt' for the 'invno' variable. Thanks again! Bryan

I am using SQL Server 2000 and CR9. While we do store Invoice Numbers in the DB and we have User Functions to Auto-Generate Numbers, I need this done in CR. I basically Just want to use the parameter, which is a date, and append an incremented number to the end of it. The Number needs to show...